On 2006-09-06, Tom Lane <[EMAIL PROTECTED]> wrote:
> Martijn van Oosterhout <kleptog@svana.org> writes:
>> In the CVS version there is a table with this information:
>> http://developer.postgresql.org/pgdocs/postgres/view-pg-timezonenames.html
> Actually, what that view gives you is timezone offset abbreviations, not
> the full zone names that you could use with SET TIME ZONE.  It strikes
> me that we should have a view for that as well.  We could use code
> similar to scan_available_timezones() to generate the view output.

Any view over the full timezone names should also include the corresponding
data from zone.tab in the timezone library source.

> It's somewhat urgent to address this now, because pg_timezonenames is
> sitting on the obvious name for such a view, and once we release 8.2
> we won't be able to change it.  On reflection I think the existing view
> is wrongly named --- perhaps it should be pg_timezoneabbrevs?  Or
> more readably, perhaps pg_timezone_abbrevs, with pg_timezone_names for
> the other view.

Yes, the abbreviations table is definitely misnamed.

Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to