null value in date field - Mailing list pgsql-novice

From Jeff Deroshia
Subject null value in date field
Date
Msg-id E60BCB22-4385-11D7-9E8D-000393A34A52@hal.physast.uga.edu
Whole thread Raw
Responses Re: null value in date field
Re: null value in date field
List pgsql-novice
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


pgsql-novice by date:

Previous
From: ninja
Date:
Subject: base36 sequence
Next
From: Andrew McMillan
Date:
Subject: Re: Accessing PostgreSQL from a remote host