On 4/18/19 11:36 AM, Ravi Krishna wrote:
Not able to produce this with PG 11.1
If col1 is any type other than boolean, the update statement fails in syntax.
If col1 is boolean, then it updated it correctly. In other words
update col1 = NULL
and col2 in (1,2)
is treated same as
update col1 = NULL
where col2 in (1,2)
The above is not the same format as OP's query:
Update tableA set col1 = null and col2 in (1,2);
Also I checked it on DB2 which rejected the UPDATE sql as bad syntax, as expected.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
