pgsql: Improve documentation and testing of jsonpath string() for datet

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Improve documentation and testing of jsonpath string() for datet
Date: 2024-09-10 18:48:22
Message-ID: E1so5uY-000TUa-I0@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improve documentation and testing of jsonpath string() for datetimes.

Point out that the output format depends on DateStyle, and test that,
along with testing some cases previously not covered.

In passing, adjust the horology test to verify that the prevailing
DateStyle is 'Postgres, MDY', much as it has long verified the
prevailing TimeZone. We expect pg_regress to have set these up,
and there are multiple regression tests relying on these settings.

Also make the formatting of entries in table 9.50 more consistent.

David Wheeler (marginal additional hacking by me); review by jian he

Discussion: https://postgr.es/m/56955B33-6959-4FDA-A459-F00363ECDFEE@justatheory.com

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/func.sgml | 16 +++--
src/test/regress/expected/horology.out | 9 ++-
src/test/regress/expected/jsonb_jsonpath.out | 103 +++++++++++++++++++++++++--
src/test/regress/sql/horology.sql | 4 +-
src/test/regress/sql/jsonb_jsonpath.sql | 22 +++++-
5 files changed, 135 insertions(+), 19 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2024-09-10 20:20:38 pgsql: Fix some whitespace issues in XMLSERIALIZE(... INDENT).
Previous Message Tomas Vondra 2024-09-10 14:30:56 pgsql: Add PG_TEST_PG_COMBINEBACKUP_MODE to CI tasks