Skip site navigation (1) Skip section navigation (2)

Re: timestamp in 7.2

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <mark(at)vestnesis(dot)lv>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: timestamp in 7.2
Date: 2002-03-27 17:43:08
Message-ID: 20020327094218.S38816-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, 27 Mar 2002 mark(at)vestnesis(dot)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.


In response to

pgsql-admin by date

Next:From: Richard EmbersonDate: 2002-03-27 18:06:00
Subject: ERROR: plpgsql: cache lookup for proc 17911 failed
Previous:From: Jodi KanterDate: 2002-03-27 16:58:47
Subject: pg_restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group