On Friday, March 22, 2024, Jamie Thompson <jthompson.neuk@gmail.com> wrote:Earlier today, I was running some sql for someone which they had submitted as:> UPDATE tablename SET col1 = val1 AND col2 = val2 WHERE id = XI presume these columns are booleans. So you wrote something like:Set col1 = ( true and false = true )Which in this case must coincidentally have produced whatever boolean value already existed in col1.David J.
Earlier today, I was running some sql for someone which they had submitted as:> UPDATE tablename SET col1 = val1 AND col2 = val2 WHERE id = X
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных