Re: pg 7.3 Time function not working

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Uday Walia <waliau(at)yahoo(dot)com>
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: pg 7.3 Time function not working
Date: 2003-08-28 13:34:45
Message-ID: 10575.1062077685@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Uday Walia <waliau(at)yahoo(dot)com> writes:
> We are upgrading from pg 7.1 to 7.3.3.
> The following which works on 7.1 gives error on 7.3.3.
> select time (timestamp '2003-08-30 20:30');

time(x) is a datatype name, and has been for a couple releases now.
Suggest using cast notation instead.

regards, tom lane

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fernando Nasser 2003-08-28 14:01:35 Re: binding variable length array
Previous Message Tomisław Kityński 2003-08-28 12:44:13 Re: DatabaseMetaData.get(Imi|Ex)portedKeys() and FK_NAME column