Re: Possible documentation error on pg_catalog.pg_timezone_abbrevs

On 2 August 2017 at 23:03, <joan(at)sanchezsabe(dot)com> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/view-pg-timezone-names.html
> Description:
>
> With regard to documentation page:
>
> https://www.postgresql.org/docs/current/static/view-pg-timezone-names.html
>
> Testing:
>
> SELECT name, abbrev, utc_offset, is_dst FROM pg_catalog.pg_timezone_abbrevs
> ;

The documentation page you've referred to is for pg_timezone_names,
not pg_timezone_abbrevs.

The page for pg_timezone_abbrevs doesn't mention a "name" column:
https://www.postgresql.org/docs/current/static/view-pg-timezone-abbrevs.html

>
> ... produces the error
>
> ERROR: column &quot;name&quot; does not exist
> LINE 1: SELECT name, abbrev, utc_offset, is_dst FROM pg_timezone_abb...
>
> Apparently, the column &quot;name&quot; isn&#39;t there any more.
>
> SELECT * FROM pg_catalog.pg_timezone_abbrevs LIMIT 1;
>
> produces
>
> abbrev | utc_offset | is_dst
> :----- | :--------- | :-----
> ACDT | 10:30:00 | t
>
> Either the table (or view) is lacking a column, or the documentation is
> wrong.
>
> Tested on PostgreSQL 9.6.2 at
> http://dbfiddle.uk/?rdbms=postgres_9.6&amp;fiddle=9f367fa77616ddf9af721091366bd792

Thom