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 QAA11985 for ; Sun, 18 Oct 1998 16:50:30 -0400 (EDT) (envelope-from wieck@sapserv.debis.de) Received: by dsh.de; id WAA20530; Sun, 18 Oct 1998 22:52:35 +0200 (MET DST) Received: from dshmail.dsh.de(53.47.15.3) by neptun.dsh.de via smap (3.2) id xma020527; Sun, 18 Oct 98 22:52:16 +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 WAA00593; Sun, 18 Oct 1998 22:50:11 +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 WAA15703; Sun, 18 Oct 1998 22:52:40 +0200 Received: from orion.SAPserv.Hamburg.dsh.de by mars.SAPserv.Hamburg.dsh.de with smtp for <> id m0zUxQC-000B5AC; Sun, 18 Oct 98 20:19 MET DST Received: by orion.SAPserv.Hamburg.dsh.de for jwieck@debis.com id m0zUzy8-000EBPC; Sun, 18 Oct 98 23:02 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 23:02:28 +0200 (MET DST) Cc: jwieck@debis.com, pgsql-sql@postgreSQL.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: from "ZioBudda" at Oct 18, 98 10:44:12 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > On Sun, 18 Oct 1998, Jan Wieck wrote: > > > > -- attribute a will have NULL value > > INSERT INTO mytab (b, c) VALUES ('something', 'now'); > > 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. > INSERT INTO mytab (a, b, c) VALUES (2, 'something', NULL); 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) #