Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4459A4760D4; Fri, 20 Sep 2002 08:30:53 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id D9F7C475D3F; Fri, 20 Sep 2002 08:30:52 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 2B2B9381945; Fri, 20 Sep 2002 08:30:07 -0400 (EDT) From: "Tomas Lehuta" X-Newsgroups: comp.databases.postgresql.general, comp.databases.postgresql.hackers, comp.databases.postgresql.sql Subject: timestamp parse error Date: Fri, 20 Sep 2002 14:30:08 +0200 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 19 Message-ID: X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 To: pgsql-hackers@postgresql.org, pgsql-general@postgresql.org, pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/926 X-Sequence-Number: 30507 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