Re: Units for storage of internal time zone offsets - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Units for storage of internal time zone offsets
Date
Msg-id 4546.1026227894@sss.pgh.pa.us
Whole thread Raw
In response to Units for storage of internal time zone offsets  (Thomas Lockhart <lockhart@fourpalms.org>)
List pgsql-hackers
Thomas Lockhart <lockhart@fourpalms.org> writes:
>> Is there a reason for the restriction to one byte?  Offhand I don't
>> recall that we store TZ offsets on disk at all...

> Ah, we don't. Sorry I wasn't clear. This is only for the lookup table we
> use to interpret time zones on *input*. It is contained in
> src/backend/utils/adt/datetime.c

Well, sheesh.  Let's widen the byte field to int and store all the
offsets in minutes, or even seconds.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_tables and schemas
Next
From: Bruce Momjian
Date:
Subject: Re: Postgres Projects