Re: Date question....

Is there a better way to do this?

-----Original Message-----
From: Bruno Wolff III [mailto:bruno(at)wolff(dot)to]
Sent: Thursday, May 22, 2003 10:51 AM
To: Kovalcik, Mike A [ITS]
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Date question....

On Thu, May 22, 2003 at 10:38:54 -0500,
"Kovalcik, Mike A [ITS]" <mkoval01(at)sprintspectrum(dot)com> wrote:
> Well....
>
> I set my table up like...
>
> Bday date
>
> Where bday is my column name and date is the data type....
>
> I've tried a lot of things to remove it, but I've had no luck:
>
> UPDATE address SET Bday = '' WHERE addressid = '4'
>
> This is when it gives me the error, but I'm not sure what else to put
> there to make sure it is in date format to remove the date
> completely...

If you are doing things this way then you probably want to use: UPDATE
address SET Bday = NULL WHERE addressid = '4'