On Wed, 27 Mar 2002 mark@vestnesis.lv wrote:
> 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"
timestamp is more reserved than before, I believe it'll work as
"timestamp"(...). The other form is now for specifying the precision
of a timestamp.