On Friday 21 Mar 2003 11:38 am, Christopher Kings-Lynne wrote:
> > phd=# select time(abstime(timestamp 'now')) from bookings;
> > ERROR: parser: parse error at or near "abstime" at character 13
> > phd=# select time(timestamp 'now') from bookings;
> > ERROR: parser: parse error at or near "timestamp" at character 13
> > phd=# select version();
> > version
>
> Try:
>
> select "time"(abstime(timestamp 'now')) from bookings;
> select "time"(timestamp 'now') from bookings;
First of all, thanks, it worked..
And What's so holy about "" if it is a function?
That was bummer, I admit.. Spent almost a day on it..
Shridhar
P.S. Sorry, I didn't realized that I handn' CC hackers..
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
