Received: from mail2.uniserve.com (mail2.uniserve.com [204.244.156.10]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f2ULUlK41289 for ; Fri, 30 Mar 2001 16:30:47 -0500 (EST) (envelope-from gutz@kalador.com) Received: from van5d42.dial.uniserve.ca ([204.244.163.153] helo=gutz) by mail2.uniserve.com with smtp (Exim 3.13 #1) id 14j6Th-000Bch-00; Fri, 30 Mar 2001 13:30:41 -0800 From: "Gerald Gutierrez" To: "Maurizio Ortolan" , Subject: RE: Error in the date field (with NULL value...).Thanks! Date: Fri, 30 Mar 2001 13:36:38 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <5.0.2.1.2.20010329064845.00a9e9b0@box.tin.it> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200103/651 X-Sequence-Number: 2330 Perhaps you can run your file through a filter to replace '' to null. Any of sed, perl, python and other scripting languages would do nicely. e.g. sed -e "s/''/null/g" < myfile > myfile2 -----Original Message----- From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Maurizio Ortolan Sent: Thursday, March 29, 2001 6:50 AM To: pgsql-hackers@postgresql.org Cc: pgsql-sql@postgresql.org; pgsql-general@postgresql.org; crix98@hotmail.com Subject: [SQL] Error in the date field (with NULL value...).Thanks! ... My question: How can I resolv my problem? I have a big data file to import where in the 2nd date field there is '' instead of null .... How can I "binds" PostgreSQL to consider '' as null ? Many thanks for any suggestions! CIAO! MAURIZIO ******************************************* ** Happy surfing on THE NET !! ** ** Ciao by ** ** C R I X 98 ** ******************************************* AntiSpam: rimuovere il trattino basso dall'indirizzo per scrivermi... (delete the underscore from the e-mail address to reply) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl