Horton

RE: [SQL] NULL DATE

Taral <taral@mail.utexas.edu>

View thread View on postgr.es
From: "Taral" <taral@mail.utexas.edu>
To: "ZioBudda" <michel@michel.enter.it>, "Jan Wieck" <jwieck@debis.com>
Cc: <pgsql-sql@postgreSQL.org>
Date: 1998-10-18T21:03:59Z
Lists: pgsql-sql 
> ok..
> but i have the case
> 	INSERT INTO mytab (a,b,c) VALUES(2,'something','now');
> 	now i want to set NULL the date item in this tuple.

either:

INSERT INTO mytab (a,b) VALUES (2,''something');

or if it exists already:

UPDATE mytab SET c = NULL;

Taral