Received: from dsh.de (firewall-user@neptun.sns-felb.debis.de [53.122.101.2]) by hub.org (8.8.8/8.8.8) with ESMTP id QAA11161 for ; Sun, 18 Oct 1998 16:44:13 -0400 (EDT) (envelope-from wieck@sapserv.debis.de) Received: by dsh.de; id WAA20106; Sun, 18 Oct 1998 22:46:26 +0200 (MET DST) Received: from dshmail.dsh.de(53.47.15.3) by neptun.dsh.de via smap (3.2) id xma020094; Sun, 18 Oct 98 22:46:10 +0200 Received: from mail1.hh1.dsh.de (mail1.hh1.dsh.de [53.47.9.5]) by dshmail.dsh.de (8.8.7/8.8.7) with ESMTP id WAA00464; Sun, 18 Oct 1998 22:44:02 +0200 (MET DST) Received: from mars.SAPserv.Hamburg.dsh.de (root@mail5.hh1.dsh.de [53.2.168.17]) by mail1.hh1.dsh.de (8.8.7/8.8.7) with SMTP id WAA15671; Sun, 18 Oct 1998 22:46:30 +0200 Received: from orion.SAPserv.Hamburg.dsh.de by mars.SAPserv.Hamburg.dsh.de with smtp for <> id m0zUxKE-000B5AC; Sun, 18 Oct 98 20:13 MET DST Received: by orion.SAPserv.Hamburg.dsh.de for michel@michel.enter.it id m0zUzsA-000EBPC; Sun, 18 Oct 98 22:56 MET DST Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] NULL DATE To: michel@michel.enter.it Date: Sun, 18 Oct 1998 22:56:18 +0200 (MET DST) Cc: pgsql-sql@postgreSQL.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: from "Michel \\'ZioBudda\\' Morelli" at Oct 18, 98 10:28:51 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > 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@debis.com (Jan Wieck) #