parse error ???

From: greg(at)proterians(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: parse error ???
Date: 1999-12-09 10:29:31
Message-ID: Pine.LNX.4.05.9912091122410.18605-100000@proterians.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have one question...

Why postgres returns parse error when i send

select birth_time::date from table;


parse error at or near ":"


I use CBuilder4 and postODBC driver...

when I write

select date(birth_time) from table;

it works...


but in DataBaseExplorer the first query works fine....

please help....

--Greg--

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dev Elop 1999-12-09 10:36:40 Re: [GENERAL] get the previous assigned sequence value
Previous Message Bruce Momjian 1999-12-09 05:28:01 Re: [GENERAL] View / Unions