From: | joan(at)sanchezsabe(dot)com |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | Possible documentation error on pg_catalog.pg_timezone_abbrevs |
Date: | 2017-08-02 22:03:28 |
Message-ID: | 20170802220328.8429.72687@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2017-08-02 23:37:20 | Re: Possible documentation error on pg_catalog.pg_timezone_abbrevs |
Previous Message | Tom Lane | 2017-08-02 20:28:46 | Re: Client interface for Tcl |