Received: from ecbull20.frec.bull.fr (ecbull20.frec.bull.fr [129.183.4.3] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id FAA96538 for ; Fri, 9 Jul 1999 05:26:04 -0400 (EDT) (envelope-from Roland.Dubouloz@bull.net) Received: from dubouloz1.frec.bull.fr (root@dubouloz1.frec.bull.fr [129.183.19.130]) by ecbull20.frec.bull.fr (8.9.2/8.9.1) with ESMTP id LAA49658 for ; Fri, 9 Jul 1999 11:27:25 +0200 Received: from dubouloz1 (localhost [127.0.0.1]) by dubouloz1.frec.bull.fr (8.8.5/8.8.5) with SMTP id LAA14104 for ; Fri, 9 Jul 1999 11:25:13 +0200 Sender: dubouloz@dubouloz1.frec.bull.fr Message-ID: <3785BFF9.B569809@bull.net> Date: Fri, 09 Jul 1999 11:25:13 +0200 From: Roland_DUBOULOZ X-Mailer: Mozilla 3.01 (X11; I; Linux 2.0.29 i586) MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: Bad date representation Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Is there a bug in the postmaster ? with -e option the date must be in European format but with no options the date may be in European or American format ! create table FOO (date date); 1.- postmaster -i -o -e insert into FOO values('20-06-1999'); insert into FOO values('06-21-1999'); we have a "Bad date external representation" that is true. 2.-postmaster -i insert into FOO values('06-22-1999'); insert into FOO values('06-07-1999'); insert into FOO values('23-06-1999'); <---- no ERROR WE Have NO ERROR !!!!! why ??? and on select * from FOO the result is date ---------- 06-22-1999 06-07-1999 06-23-1999 -- Roland Dubouloz BULL XS/BU BULL SA mailto:Roland.Dubouloz@bull.net 1,Rue de Provence Phone :+33 (0)4 76 29 77 87 BP 208 Bullcom : 229-7787 38432 Echirolles CEDEX Office : A1-052 France Fax : +33 (0)4 76 29 70 02