Thomas Lockhart <lockhart@fourpalms.org> writes:
>> 2. Is this really supposed to work? More precisely: can I count on it if future
>> releases? The documentation
>> (http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-select.html) does not
>> mention it....
> Sure. Well, very likely anyway. AT TIME ZONE is defined in SQL9x, so we
> are likely to continue to support it.
I'd hardly expect the SELECT reference page to mention every possible
expression construct. I do find it documented in the place I'd expect
to look for it:
http://developer.postgresql.org/docs/postgres/datatype-datetime.html#DATATYPE-TIMEZONES
regards, tom lane