Re: [HACKERS] [GENERAL] timestamp parse error

2002-09-20 Thread Stephan Szabo
On Fri, 20 Sep 2002, Tomas Lehuta wrote: Hello! i'm using PostgreSQL 7.2.1 and got strange parse errors.. could somebody tell me what's wrong with this timestamp query example? PostgreSQL said: ERROR: parser: parse error at or near date Your query: select timestamp(date '1998-02-24',

Re: [HACKERS] [GENERAL] timestamp parse error

2002-09-20 Thread Tom Lane
Tomas Lehuta [EMAIL PROTECTED] writes: could somebody tell me what's wrong with this timestamp query example? select timestamp(date '1998-02-24', time '23:07') PostgreSQL said: ERROR: parser: parse error at or near date example is from PostgreSQL help From where exactly? I don't see any