Thread: pgsql: Doc: document POSIX-style time zone specifications in full.

pgsql: Doc: document POSIX-style time zone specifications in full.

From
Tom Lane
Date:
Doc: document POSIX-style time zone specifications in full.

We'd glossed over most of this complexity for years, but it's hard
to avoid writing it all down now, so that we can explain what happens
when there's no "posixrules" file in the IANA time zone database.
That was at best a tiny minority situation till now, but it's likely
to become quite common in the future, so we'd better explain it.

Nonetheless, we don't really encourage people to use POSIX zone specs;
picking a named zone is almost always what you really want, unless
perhaps you're stuck with an out-of-date zone database.  Therefore,
let's shove all this detail into an appendix.

Patch by me; thanks to Robert Haas for help with some awkward wording.

Discussion: https://postgr.es/m/1390.1562258309@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a3235a53ae9f6f21f823081c610b0901db6aa665

Modified Files
--------------
doc/src/sgml/datatype.sgml |  38 ++------
doc/src/sgml/datetime.sgml | 212 +++++++++++++++++++++++++++++++++++++++++++++
2 files changed, 217 insertions(+), 33 deletions(-)