Postgres Pro
Downloads
Home   >   mailing lists

Re: pg 7.3 Time function not working - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: pg 7.3 Time function not working
Date
Msg-id 10575.1062077685@sss.pgh.pa.us
Whole thread Raw
In response to pg 7.3 Time function not working  (Uday Walia <waliau@yahoo.com>)
List pgsql-jdbc
Tree view 
Uday Walia <waliau@yahoo.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

pgsql-jdbc by date:

Previous
From: Toby Doig
Date:
Subject: Re: Help - lo_close: invalid large obj descriptor
Next
From: Fernando Nasser
Date:
Subject: Re: binding variable length array