Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: DATE column doesn't like empty string or null value
Date
Msg-id 6493.1093374688@sss.pgh.pa.us
Whole thread Raw
In response to DATE column doesn't like empty string or null value  (michael@floog.net)
Responses Re: DATE column doesn't like empty string or null value
List pgsql-novice
Tree view 
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 Tom
Date:
Subject: drop all tables in db - without dropdb ?!
Next
From: Tom Lane
Date:
Subject: Re: Authentication problems