RE: [SQL] NULL DATE

From: "Taral" <taral(at)mail(dot)utexas(dot)edu>
To: "ZioBudda" <michel(at)michel(dot)enter(dot)it>, "Jan Wieck" <jwieck(at)debis(dot)com>
Cc: <pgsql-sql(at)postgreSQL(dot)org>
Subject: RE: [SQL] NULL DATE
Date: 1998-10-18 21:03:59
Message-ID: 000a01bdfada$d3c41720$3b291f0a@taral
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ulf Mehlig 1998-10-19 07:39:47 `statistical' aggregate functions etc.
Previous Message Jan Wieck 1998-10-18 21:02:28 Re: [SQL] NULL DATE