Re: null value in date field

On Tue, 18 Feb 2003, Jeff Deroshia wrote:

> I have a form that contains optional DATE fields. To enter null
> values, I've tried null, 'null', '', '-', '0', 0, and each time I get
> the following error:
>
> ERROR: Bad numeric input format ''

Are you sure this is on a date field? Date should be giving you
something like (at least in 7.3):
ERROR: Bad date external representation ''

Null works for me...
sszabo=# create table test(a date);
CREATE TABLE
sszabo=# insert into test (a) values (null);
INSERT 4256129 1
sszabo=# insert into test (a) values ('');
ERROR: Bad date external representation ''