Re: Units for storage of internal time zone offsets

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Units for storage of internal time zone offsets
Date: 2002-07-09 15:27:23
Message-ID: 3D2B00DB.20C59F4D@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-07-09 15:41:58 Re: (A) native Windows port
Previous Message Tom Lane 2002-07-09 15:26:55 Re: Issues Outstanding for Point In Time Recovery (PITR)