Received: from mail.tol.it ([194.243.154.49]) by hub.org (8.8.8/8.7.5) with ESMTP id HAA22369 for ; Mon, 13 Jul 1998 07:03:14 -0400 (EDT) Received: from maya.wonderland.org (a-ol1-57.tin.it [212.216.163.56]) by mail.tol.it (8.8.4/8.8.4) with ESMTP id NAA04464; Mon, 13 Jul 1998 13:02:47 +0200 (MET DST) Received: from maya.wonderland.org (serbr@localhost [127.0.0.1]) by maya.wonderland.org (8.8.7/8.8.8) with ESMTP id MAA01703; Mon, 13 Jul 1998 12:51:06 +0200 Message-Id: <199807131051.MAA01703@maya.wonderland.org> X-Mailer: exmh version 2.0.2 2/24/98 To: pgsql-sql@postgreSQL.org cc: serbr@tin.it Subject: [SQL] empty data Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Mon, 13 Jul 1998 12:51:04 +0200 From: Sergio Brandano > serbr=> CREATE TABLE foo (mtdata date); > CREATE > serbr=> \dt > > Database = serbr > +------------------+----------------------------------+----------+ > | Owner | Relation | Type | > +------------------+----------------------------------+----------+ > | serbr | foo | table | > +------------------+----------------------------------+----------+ > serbr=> INSERT INTO foo VALUES (''); > ERROR: Bad date external representation > serbr=> INSERT INTO foo VALUES ('//'); > ERROR: Bad date external representation My problem arise in a more general context, where the date may not be available at the time of data insert/update, and the data must be empty. What can I do? (I would not like to define a my own date-type...) Sergio