Mirko Pace <mirkop82@gmail.com> wrote:
> I've ran an update statement like this (obviously wrong, I know!):
> update my_table
> set boolean_field = true AND
> my_notes = 'something'
> where id in
> (select id from my_table order by random() limit 4000);
> in my psql client and I had a "UPDATE 4000" result but, correctly, anything
> was changed in my_table.
> So... why pg didn't raise a warning about syntax issue?
Because there is no syntax error? "TRUE AND my_notes =
'something'" is a valid expression (and equivalent to
"my_notes = 'something'").
Tim