Re: Timestamp vs timestamptz

* Tom Lane:

> Florian Weimer <fweimer@bfk.de> writes:
>> * Agent M.:
>>> timestamp with time zone does not record the timezone you inserted it
>>> with- it simply stores the GMT version and converts to whatever
>>> timezone you like on demand.
>
>> Are you sure?  This behavior is not documented, and I can't reproduce
>> it with PostgresQL 8.1.4.
>
> Huh?  Section 8.5.1.3. Time Stamps says

Oops, I misread what Agent M wrote--"timestamp with time zone" vs
"timestamp with time zone".  Sorry about that.

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Durlacher Allee 47            tel: +49-721-96201-1
D-76131 Karlsruhe             fax: +49-721-96201-99