Thread: pgsql: Implement TZH and TZM timestamp format patterns

Implement TZH and TZM timestamp format patterns

These are compatible with Oracle and required for the datetime template
language for jsonpath in an upcoming patch.

Nikita Glukhov and Andrew Dunstan, reviewed by Pavel Stehule.

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/11b623dd0a2c385719ebbbdd42dd4ec395dcdc9d

Modified Files
--------------
doc/src/sgml/func.sgml                    |  8 ++++
src/backend/utils/adt/formatting.c        | 69 +++++++++++++++++++++++++++--
src/test/regress/expected/horology.out    | 30 +++++++++++++
src/test/regress/expected/timestamptz.out | 72 ++++++++++++++++++-------------
src/test/regress/sql/horology.sql         |  6 +++
src/test/regress/sql/timestamptz.sql      | 20 +++++----
6 files changed, 164 insertions(+), 41 deletions(-)