Re: Why data of timestamptz does not store value of timezone passed to it? - Mailing list pgsql-hackers

Hi Craig,

On Fri, Aug 29, 2014 at 10:17:17AM +0800, Craig Ringer wrote:
> (...) It should also discuss the approach of storing a (instant
> timestamptz, timezone text) or (instant timestampts, tzoffset
> smallint) tuple for when unambiguous representation is required.
> 
> (I guess I just volunteered myself to write a draft of that).

Please notice that smallint is too small for tzoffset:
 SELECT d AT TIME ZONE 'Europe/Berlin'      - d AT TIME ZONE 'Europe/Paris' FROM (   VALUES     (date '1815-10-31')   ,
(date'1897-02-19') ) AS f(d);
 

Cheers,
Dr. Gianni Ciolli - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gianni.ciolli@2ndquadrant.it | www.2ndquadrant.it