null date fields - Mailing list pgsql-admin

From Marco Tulio
Subject null date fields
Date
Msg-id GRG1VV$Iy95UCi1codE8Q1YH1k9Mm_VnNHIAJxdUQldwnPX95VJ6@bol.com.br
Whole thread Raw
Responses Re: null date fields
List pgsql-admin
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, sales) VALUES (1,'');

And I need write codes for translate the porting to:

INSERT INTO order (order_id, sales) VALUES (1,NULL);


Has any place to change this in configuration directory ?


((I need say that´s my English is soo poor ?? :-))

-----------

Marco Tulio
Desenvolvimento de sistemas para Internet


__________________________________________________________________________
Quer ter seu próprio endereço na Internet?
Garanta já o seu e ainda ganhe cinco e-mails personalizados.
DomíniosBOL - http://dominios.bol.com.br



pgsql-admin by date:

Previous
From: Manuel Trujillo
Date:
Subject: Re: stopping "wal"
Next
From: Peter Eisentraut
Date:
Subject: Re: null date fields