Re: Surprise AT TIME ZONE behaviour (buglet?)? - Mailing list pgsql-general

From Tom Lane
Subject Re: Surprise AT TIME ZONE behaviour (buglet?)?
Date
Msg-id 11863.1012853056@sss.pgh.pa.us
Whole thread Raw
In response to Re: Surprise AT TIME ZONE behaviour (buglet?)?  (Thomas Lockhart <lockhart@fourpalms.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Surprise AT TIME ZONE behaviour (buglet?)?
Next
From: david blood
Date:
Subject: Long column names and table names