Re: [ADMIN] null date fields

2002-02-12 Thread Peter Eisentraut
Marco Tulio writes: > Its every time a big problem when porting data from > another databases to PostgreSQL. > > I ever need translate null date fields to "NULL" string, > instead the normal '' sintaxe. It's not normal, it's wrong. > Has any place to change this in configuration directory ? No

[ADMIN] null date fields

2002-02-12 Thread Marco Tulio
Its every time a big problem when porting data from another databases to PostgreSQL. I ever need translate null date fields to "NULL" string, instead the normal '' sintaxe. Considering this table: CREATE TABLE order (order_id int4, sale date); This causes error: INSERT INTO order (order_id