> > 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?
It's really old 7.1 syntax, not supported from 7.2+.
Basically it's because time can now have a precision. eg. a field of type
TIME(4) will have decimal places of millisecond precision. You need to
quote the function to make it get treated as a function rather than a type
definition...
A better (standard) way to express it is probably:
select cast(cast(current_timestamp as abstime) as time) from bookings;
or even
select current_timestamp::abstime::time from bookings;
Chris
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
