pgsql: Doc: document EXTRACT(JULIAN ...), improve Julian Date explanati - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Doc: document EXTRACT(JULIAN ...), improve Julian Date explanati
Date
Msg-id E1lb3Vj-00064d-Kn@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Doc: document EXTRACT(JULIAN ...), improve Julian Date explanation.

For some reason, the "julian" option for extract()/date_part() has
never gotten listed in the manual.  Also, while Appendix B mentioned
in passing that we don't conform to the usual astronomical definition
that a Julian date starts at noon UTC, it was kind of vague about what
we do instead.  Clarify that, and add an example showing how to get
the astronomical definition if you want it.

It's been like this for ages, so back-patch to all supported branches.

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

Branch
------
REL_12_STABLE

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

Modified Files
--------------
doc/src/sgml/datetime.sgml | 46 ++++++++++++++++++++++++++++++++++++++++------
doc/src/sgml/func.sgml     | 22 +++++++++++++++++++++-
2 files changed, 61 insertions(+), 7 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Fix pg_upgrade test on Cygwin
Next
From: Tom Lane
Date:
Subject: pgsql: Remove rewriteTargetListIU's expansion of view targetlists in UP