Boris writes:
> insert into table test (...) values ('2001-03-03') works.
>
> insert into table test (...) values ('NULL') does not work,
> but in mysql it works.
That doesn't necessarily mean that MySQL is right.
> It would be great if there would be a way for 'NULL' and NULL to make
> everything more compatible.
That would certainly make everything *less* 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).
If you want to change the display of NULLs in the psql frontend, use the
\pset null command.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/