Re: [PATCHES] Error in the date field (with NULL value...).Thanks!

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Maurizio Ortolan <crix98__(at)tin(dot)it>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-ports(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCHES] Error in the date field (with NULL value...).Thanks!
Date: 2001-03-30 06:22:21
Message-ID: 3AC4261D.4B452415@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs pgsql-general pgsql-hackers pgsql-patches pgsql-ports pgsql-sql

> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Pete Forman 2001-03-30 10:07:25 Re: Re: [PORTS] pgmonitor and Solaris
Previous Message Bruce Momjian 2001-03-30 03:12:45 User administration tool

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-03-30 13:35:37 unix_socket_directory isn't used by all bin tools
Previous Message sasha 2001-03-30 05:37:49 PORTS : Windows 95/98/2000

Browse pgsql-general by date

  From Date Subject
Next Message Trewern, Ben 2001-03-30 08:12:10 RE: Starting postgresql on startup
Previous Message diana 2001-03-30 06:09:30 function to create a table

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2001-03-30 07:03:55 AW: Unsigned int functions
Previous Message Thomas Lockhart 2001-03-30 06:17:31 Re: Unsigned int functions

Browse pgsql-patches by date

  From Date Subject
Next Message Justin Clift 2001-03-30 06:40:24 Modulo bug patch for 7.0.3
Previous Message Bruce Momjian 2001-03-30 03:49:42 Re: Re: [ODBC] Cleanup of ODBC

Browse pgsql-ports by date

  From Date Subject
Next Message sasha 2001-03-30 06:31:25 NOTICE: IpcMemoryDetach: shmdt(0x???????): Invalid argument
Previous Message Jason Tishler 2001-03-29 21:55:17 Re: Cygwin PostgreSQL Regression Test Problems (Revisited)

Browse pgsql-sql by date

  From Date Subject
Next Message Alessio Bragadini 2001-03-30 07:30:40 'Include' function in SQL scripts
Previous Message Tom Lane 2001-03-30 06:15:15 Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1