Possible documentation error on pg_catalog.pg_timezone_abbrevs

On 2 August 2017 at 23:03, <joan@sanchezsabe.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;amp;fiddle=9f367fa77616ddf9af721091366bd792

Thom

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs