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

From Thomas Lockhart
Subject Re: Units for storage of internal time zone offsets
Date
Msg-id 3D2B00DB.20C59F4D@fourpalms.org
Whole thread Raw
In response to Units for storage of internal time zone offsets  (Thomas Lockhart <lockhart@fourpalms.org>)
List pgsql-hackers
> Well, sheesh.  Let's widen the byte field to int and store all the
> offsets in minutes, or even seconds.

It doesn't really matter, since the table is used only internally, and
only holds current accepted values for time zone offsets. The current
scheme works.

It might be useful to change the units, but how they are stored is an
internal detail without much importance. Someone at some point decided
that minimizing row width and table size was important (probably back in
1989 ;) and the table is structured with that in mind.
                - Thomas


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] CRC function? (fwd)
Next
From: Oliver Elphick
Date:
Subject: Re: (A) native Windows port