Re: Date data type

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@une.edu.au