Mike Hall wrote:
Gday,
I'm currently converting an MS Access database to PostgreSQL (version 8.1 as it is the vesion that ships with CentOS 5).
I'm having trouble with an INSERT statement attempting to insert an empty value ('') into a field with data type DATE. This produces the following error message:
ERROR: invalid input syntax for type date: ""
It does the same whether the field has a NOT NULL restraint or not.
I can't find anything relevant in the documentation.
What am I doing wrong.
You're trying to put the empty string into a date field
insert into atable (date_col) values (''); -- syntax error
insert into atable (date_col) values (null); -- works
klint.
--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350
Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@xxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
