pgsql: Doc: document EXTRACT(JULIAN ...), improve Julian Date explanati

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: document EXTRACT(JULIAN ...), improve Julian Date explanati
Date: 2021-04-26 15:50:59
Message-ID: E1lb3Vj-00064Z-Jy@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/79a5928ebcb726b7061bf265b5c6990e835e8c4f

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

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2021-04-26 17:58:41 pgsql: Remove rewriteTargetListIU's expansion of view targetlists in UP
Previous Message Peter Eisentraut 2021-04-26 10:20:54 pgsql: Fix pg_upgrade test on Cygwin