Re: [GENERAL] Empty Date Field - Mailing list pgsql-general

From Chris Bitmead
Subject Re: [GENERAL] Empty Date Field
Date
Msg-id 37362493.E395E514@bigfoot.com
Whole thread Raw
In response to Empty Date Field  ("fabian baena" <fabbaena@hotmail.com>)
List pgsql-general
Set the field to null. i.e.
update foo set datetime=null where...

fabian baena wrote:
>
> Hi, could any one tell me how can I tell postgres that a date field I made
> in a table can be empty.
>
> I created a table with a field like that but I didn't tell it "not null" in
> the declaration, and when I try to fill this table with an empty date it
> gives me an error.
>
> Thank you.
>
> Fabian.
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com

pgsql-general by date:

Previous
From: "fabian baena"
Date:
Subject: Re: [GENERAL] Empty Date Field
Next
From: darold
Date:
Subject: Re: [GENERAL] Restore from dump file: parse error