Postgres Pro
Downloads
Home   >   mailing lists

Re: DATE column doesn't like empty string or null value - Mailing list pgsql-novice

From michael@floog.net
Subject Re: DATE column doesn't like empty string or null value
Date
Msg-id 1093376938.412b9baa89e53@webmail.floog.net
Whole thread Raw
In response to Re: DATE column doesn't like empty string or null value  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
Tom,

Thanks for the speedy reply.
I'm going to ssh to my home-box and give this a try right now.

Mike


Quoting Tom Lane <tgl@sss.pgh.pa.us>:

> michael@floog.net writes:
> > What command can I use to remove all the 01/01/2001 entries in
> every row
> > and leave it blank.
>
> Set the values to NULL, eg
>     UPDATE mytab SET datecol = NULL;
>
>             regards, tom lane
>

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Authentication problems
Next
From: Josh Berkus
Date:
Subject: Re: drop all tables in db - without dropdb ?!