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.