Re: Insert into a date field - Mailing list pgsql-sql

Ezequias Rodrigues da Rocha wrote:
> Hi list,
> 
> I am trying to insert a record in a table with a date field but the
> postgresql reports me the following error:
> 
> ERROR: column "data_nascimento" is of type date but expression is of type
> integer
> SQL state: 42804
> Hint: You will need to rewrite or cast the expression.
> 
> 
> I tryed like this:
> 
> 
> '1963-09-01'
> '1963-09-01'::date
> 1963-09-01

Show us the whole statement - this doesn't look like the error to me.

--   Richard Huxton  Archonet Ltd