[DOCS] Possible documentation error on pg_catalog.pg_timezone_abbrevs - Mailing list pgsql-docs

From joan@sanchezsabe.com
Subject [DOCS] Possible documentation error on pg_catalog.pg_timezone_abbrevs
Date
Msg-id 20170802220328.8429.72687@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [DOCS] Possible documentation error on pg_catalog.pg_timezone_abbrevs
List pgsql-docs
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
;

... produces the error 

ERROR:  column "name" does not exist
LINE 1: SELECT name, abbrev, utc_offset, is_dst FROM pg_timezone_abb...

Apparently, the column "name" isn'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&fiddle=9f367fa77616ddf9af721091366bd792


pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [DOCS] Client interface for Tcl
Next
From: Thom Brown
Date:
Subject: Re: [DOCS] Possible documentation error on pg_catalog.pg_timezone_abbrevs