timestamp parse error

From: "Tomas Lehuta" <lharp(at)aurius(dot)sk>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: timestamp parse error
Date: 2002-09-20 12:30:08
Message-ID: amf4ce$2kle$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

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', time '23:07')

example is from PostgreSQL help and certainly worked in previous versions of
pgsql.. but in 7.2.1 it does not. had anything changed and not been updated
in pgsql manuals or is it a bug?

thanx for any help

Tomas Lehuta

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henrik Steffen 2002-09-20 12:49:25 boolean
Previous Message Jeff Davis 2002-09-20 10:54:15 Re: PHP + PostgreSQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Nigel J. Andrews 2002-09-20 12:32:52 Re: SCSI Error
Previous Message Ricardo Fogliati 2002-09-20 12:08:51 SCSI Error

Browse pgsql-sql by date

  From Date Subject
Next Message alexandre :: aldeia digital 2002-09-20 13:39:09 Re: Query Freeze
Previous Message Richard Huxton 2002-09-20 10:35:59 Re: