Postgres Pro
Downloads
Home   >   mailing lists

null value in date field - Mailing list pgsql-novice

From Jeff Deroshia
Subject null value in date field
Date
Msg-id C518AACE-437B-11D7-9E8D-000393A34A52@hal.physast.uga.edu
Whole thread Raw
List pgsql-novice
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
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: Adam Bultman
Date:
Subject: Re: Importing Postgres 7.1.1 DBs into Postgres 7.3.2
Next
From: Jeff Deroshia
Date:
Subject: Re: null value in date field