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.

Thanks


Michael Hall
IT Communications Officer
Alice Springs Town Council
[EMAIL PROTECTED]
(08) 8950 0561

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to