ERROR: Bad timestamp external representation '' - Mailing list pgsql-general

Hello

inserting a datetime values is possible with '2001-03-03' for example,
but inserting a 'NULL' is not possible and inserting a NULL is
possible.

Example:

PostgreSQL:

insert into table test (...) values ('2001-03-03') works.

insert into table test (...) values ('NULL') does not work,
but in mysql it works.

It would be great if there would be a way for 'NULL' and NULL to make
everything more compatible.

inserting a "NULL" in MySQL will be displayed as "NULL" and in
postgres as "" but if you select the row with NULL it is both
dispplayed correctly (select .. from .. where date = 'NULL' works, if
content = "" or "NULL", thats good).


--
Boris [MCSE, CNA]
...................................................................
 X-ITEC : Consulting * Programming * Net-Security * Crypto-Research
........: [PRIVATE ADDRESS:]
        : Boris Köster eMail koester@x-itec.de http://www.x-itec.de
        : Grüne 33-57368 Lennestadt Germany Tel: +49 (0)2721 989400
        : 101  PERFECTION - SECURITY - STABILITY - FUNCTIONALITY
........:..........................................................

Everything I am writing is (c) by Boris Köster and may not be
rewritten or distributed in any way without my permission.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: interval output format ?
Next
From: "Jeff Williams"
Date:
Subject: Installation on Windows 2000