Postgres Pro
Downloads
Home   >   mailing lists

Re: Updates with NULL - Mailing list pgsql-general

From Tom Lane
Subject Re: Updates with NULL
Date
Msg-id 10582.1063639078@sss.pgh.pa.us
Whole thread Raw
In response to Updates with NULL  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: Updates with NULL
List pgsql-general
Tree view 
"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> writes:
> Following seems to be the valid syntax in oracle.

> Update foo set somefield=NULL where somefield >9;

AFAIK that's valid syntax in Postgres and the SQL standard, too.

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Does "vacuum analyze" contain "vacuum"?
Next
From: Manfred Koizar
Date:
Subject: Re: Updates with NULL