date default - Mailing list pgsql-novice

From Robert Morgan
Subject date default
Date
Msg-id 40B56EEF.1090208@ihug.co.nz
Whole thread Raw
Responses Re: date default
List pgsql-novice
I'm updating a table that has a field which is datatype 'date' this
field maybe filled out or not before update. If the field  is left blank
I get an error, if I test to see if the field is empty and if it is, set
the value to 0001/01/01 then postgres will accept this. I would rather
the field remained empty but setting the field to 'null' is not accepted
by postgres. Im using php to test and set the value.

Bob



pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: questions on crosstab/coss-referenced queries
Next
From: Oliver Elphick
Date:
Subject: Re: date default