On 12/15/13, 12:59 PM, Pavel Stehule wrote:
    Why wouldn't we have a version that optionally accepts the timezone? That 
mirrors what you can currently do with a cast from text, and having to set the 
GUC if you need a different TZ would be a real PITA.

It is not bad idea.

What will be format for timezone in this case? Is a doble enough?

Sorry for not seeing this earlier, but no, I think double is barking up the 
wrong tree. It should accept the same timezone identifiers that the rest of the 
system does, like blah AT TIME ZONE foo and SET timezone = foo;

Specifically, it needs to support things like 'GMT' and 'CST6CDT'.

I can see an argument for another version that accepts numeric so if you want 
to do -11.5 you don't have to wrap it in quotes...
Jim C. Nasby, Data Architect                       j...@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to