Re: Updates with NULL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: shridhar_daithankar(at)persistent(dot)co(dot)in
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Updates with NULL
Date: 2003-09-15 15:17:58
Message-ID: 10582.1063639078@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Manfred Koizar 2003-09-15 15:20:16 Re: Updates with NULL
Previous Message Andrew Sullivan 2003-09-15 15:17:47 Re: Does "vacuum analyze" contain "vacuum"?