Re: Timezone view - Mailing list pgsql-hackers

From Naz Gassiep
Subject Re: Timezone view
Date
Msg-id 47BC58BF.4060608@mira.net
Whole thread Raw
In response to Re: Timezone view  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Timezone view  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
Tom Lane wrote:
> Naz Gassiep <naz@mira.net> writes:
>   
>> I think that it would be great if the pg_timezone_names and 
>> pg_timezone_abbrevs included a boolean field indicating if that item is 
>> in the Olsen DB
>>     
>
> Huh?  They're all in the Olsen DB
Not true, the zone.tab file has 398 zones defined, and in my PG 8.2 
running on Debian, there are 564 timezones listed in pg_timezone_names. 
The field I propose would indicate which 398 of those 564 are listed in 
zone.tab as those are the actual Olsen defined timezones, the rest are 
aliases.

Regards,
- Naz.


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: minimal update trigger
Next
From: Naz Gassiep
Date:
Subject: Re: Timezone view