null value in date field

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 
one of the following errors:

ERROR:  Bad numeric input format ''

ERROR:  Bad date external representation ''

Is there a correct way to enter null values into DATE fields?

Thanks,
Jeff Deroshia


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html