Re: SQL query

From: "Ravi Krishna" <srkrishna(at)myself(dot)com>
To: "Vikas Sharma" <shavikas(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: SQL query
Date: 2019-04-18 18:36:35
Message-ID: trinity-9d27ccf7-5d86-48ba-bfe7-eda427221248-1555612595046@3c-app-mailcom-lxa14
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Also I checked it on DB2 which rejected the UPDATE sql as bad syntax, as expected.

In response to

  • SQL query at 2019-04-18 16:43:41 from Vikas Sharma

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2019-04-18 18:40:15 Re: SQL query
Previous Message Adrian Klaver 2019-04-18 18:29:11 Re: ERROR: operator class "gin__int_ops" does not exist for access method "gin"