Mirko Pace <mirkop82@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
