ERROR: Bad timestamp external representation ''

From: Boris <koester(at)x-itec(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: Bad timestamp external representation ''
Date: 2001-03-18 19:16:01
Message-ID: 19104354573.20010318201601@x-itec.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)x-itec(dot)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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-18 19:30:11 Re: ERROR: Bad timestamp external representation ''
Previous Message Patrick Welche 2001-03-18 19:07:34 Re: simple question: building psql