Re: Timezone view

On Wed, Feb 20, 2008 at 11:43:43PM +0700, Naz Gassiep wrote:
> 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.

The zone.tab doesn't have all the zones. Try:

find /usr/share/zoneinfo/ -name posix -prune -o -name right -prune -o -type f |wc -l

Gives 577 on my system.

Not sure if the zone.tab is even used.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy