> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html