Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f2UEIHK49389 for ; Fri, 30 Mar 2001 09:18:17 -0500 (EST) (envelope-from pgsql-admin-owner@postgresql.org) Received: from golem.fourpalms.org (www.fourpalms.org [64.3.68.148]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f2U6MMK69618; Fri, 30 Mar 2001 01:22:22 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1]) by golem.fourpalms.org (Postfix) with ESMTP id 6C6CCFEB4; Fri, 30 Mar 2001 06:22:21 +0000 (UTC) Message-ID: <3AC4261D.4B452415@alumni.caltech.edu> Date: Fri, 30 Mar 2001 06:22:21 +0000 From: Thomas Lockhart Reply-To: lockhart@fourpalms.org Organization: Yes X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdksmp i686) X-Accept-Language: en MIME-Version: 1.0 To: Maurizio Ortolan Cc: pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org, pgsql-general@postgresql.org, pgsql-ports@postgresql.org, pgsql-admin@postgresql.org, pgsql-bugs@postgresql.org, pgsql-patches@postgresql.org Subject: Re: [PATCHES] Error in the date field (with NULL value...).Thanks! References: <5.0.2.1.2.20010328204925.033d7e68@box.tin.it> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/255 X-Sequence-Number: 1104 > How can I "binds" PostgreSQL to consider '' as null ? You can modify src/backend/utils/{datetime,date,timestamp}.c to accept an empty string as a null value. But imho it is better to fix this in your input file, perhaps using sed: sed "s/''/NULL/g" < informix.dump > pg.dump - Thomas