Tom Lane wrote:
> Naz Gassiep <naz(at)mira(dot)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.