Re: Timezone view

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.