From: | jwieck(at)debis(dot)com (Jan Wieck) |
---|---|
To: | michel(at)michel(dot)enter(dot)it |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] NULL DATE |
Date: | 1998-10-18 20:56:18 |
Message-ID: | m0zUzsA-000EBPC@orion.SAPserv.Hamburg.dsh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
>
> Hi, I have a item in a table that is a "date". I want to insert a null
> value in this item. How can I make it ? Is it possible ?
CREATE TABLE mytab (a int4, b text, c date);
-- attribute a will have NULL value
INSERT INTO mytab (b, c) VALUES ('something', 'now');
-- attribute b will have NULL value
INSERT INTO mytab (a, c) VALUES (2, 'now');
-- attribute c will have NULL value
INSERT INTO mytab (a, b) VALUES (3, 'something else');
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1998-10-18 21:02:28 | Re: [SQL] NULL DATE |
Previous Message | ZioBudda | 1998-10-18 20:44:12 | Re: [SQL] NULL DATE |