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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Doc: document EXTRACT(JULIAN ...), improve Julian Date explanati
Дата
Msg-id E1lb3Vj-00064j-LW@gemulon.postgresql.org
обсуждение исходный текст
Список 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_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/64d617de3c595226804e850b8c8a45517f794932

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


В списке pgsql-committers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Fix pg_upgrade test on Cygwin
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Remove rewriteTargetListIU's expansion of view targetlists in UP