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-00064g-L6@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
------
REL_11_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/4b610547c27a93289716e09721bbb4e33e8fdecf
Modified Files
--------------
doc/src/sgml/datetime.sgml | 46 ++++++++++++++++++++++++++++++++++++++++------
doc/src/sgml/func.sgml | 22 +++++++++++++++++++++-
2 files changed, 61 insertions(+), 7 deletions(-)
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 |