Postgres Pro
Downloads
Home   >   mailing lists

null value in date field - Mailing list pgsql-general

From Jeff Deroshia
Subject null value in date field
Date
Msg-id D96825C2-4379-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-general
Tree view 
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 ''

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

Thanks,
Jeff Deroshia

pgsql-general by date:

Previous
From: Felipe Schnack
Date:
Subject: 7.3.2 psql error!
Next
From: Tim Stump
Date:
Subject: Re: nodeRead: did not find '}' at end of plan node