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.
Thisproduces 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.
Thanks
Michael Hall
IT Communications Officer
Alice Springs Town Council
mhall@astc.nt.gov.au
(08) 8950 0561