Re: null value in date field

On Tue, Feb 18, 2003 at 04:13:59PM -0500, 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
> 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?

Yes:

=> create table dummy (mydate date);
CREATE
=> insert into dummy values (null);
INSERT 3397454 1
=> select * from dummy;
mydate
--------

(1 row)

You say you tried null: what was your insert? What's the table look
like?

--keith

--
kkeller(at)speakeasy(dot)net
public key: http://wombat.san-francisco.ca.us/kkeller/kkeller.asc
alt.os.linux.slackware FAQ: http://wombat.san-francisco.ca.us/cgi-bin/fom