Re: How to store empty to Date field ? - Mailing list pgsql-general

To update all existing records with empty values:
  update table1
  set datefield = null;

To insert an empty value into a new record:
  insert into table1 (datefield) values (null);

Best of luck,

Andrew Gould

--- kingking <kingking@hknet.com> wrote:
> Dear All,
>
> How to store empty to Date field ?
>
> Thanks
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com