From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Improve documentation and testing of jsonpath string() for datet
Date: Tue, 10 Sep 2024 18:48:22 +0000
Message-ID: <E1so5uY-000TUa-I0@gemulon.postgresql.org> (raw)
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(-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Improve documentation and testing of jsonpath string() for datet
In-Reply-To: <E1so5uY-000TUa-I0@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox