timestamp in 7.2 - Mailing list pgsql-admin

From mark@vestnesis.lv
Subject timestamp in 7.2
Date
Msg-id 3CA1C15A.29615.58FACD5@localhost
Whole thread Raw
Responses Re: timestamp in 7.2  (Karel Zak <zakkr@zf.jcu.cz>)
Re: timestamp in 7.2  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
Hello all.

I'v migrated my data to 7.2.
Now I'm  testing aplications, but looks like timestamp function in
postgres is broken:
klienti=# select date(now());
    date
------------
 2002-03-27
(1 row)

klienti=# select timestamp(date(now()));
ERROR:  parser: parse error at or near "date"

I need to make querys with timestamp(date,time);
But timestamp don't work even with sample from manual:

klienti=# select timestamp(date '1998-02-24',time '23:07');
ERROR:  parser: parse error at or near "date"

Mark


pgsql-admin by date:

Previous
From: Richard Emberson
Date:
Subject: lo_unlink usage
Next
From: Karel Zak
Date:
Subject: Re: timestamp in 7.2