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@aklaver.com