Try NULL rather than ''. '' is not a null in postgres.
----- Original Message -----
From: Shalini shikha <shalini@ctlno.com>
To: <pgsql-sql@postgresql.org>
Sent: Monday, July 10, 2000 3:15 PM
Subject: [SQL] problem with date
> How can I insert/update a null value in a date field. If a try a sql
> statement like the following:
>
> update customer set birth_date = '' where cust_id like 'xyz', I get a
> error message saying: Bad date representation.
>
> Thanks in advance,
> Shalini