Re: Document DateStyle effect on jsonpath string()

David E. Wheeler <david@justatheory.com>

View thread View on postgr.es

From: "David E. Wheeler" <david@justatheory.com>

To: jian he <jian.universality@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2024-07-19T14:22:18Z

Lists: pgsql-hackers

Attachments

v3-0001-Document-impact-of-datestyle-on-jsonpath-string.patch (application/octet-stream) patch v3-0001
(unnamed) (text/plain)

On Jul 9, 2024, at 10:45, David E. Wheeler <david@justatheory.com> wrote:

>> one tiny complaint would be maybe we need `reset datestyle`.
> 
> That’s fair. Done.

Here’s a rebase on 5784a49. I also updated the commitfest item[1] to link to a new pull request[2], since I seem to have turned the other one into the tz conversion bug fix.

Best,

David

[1]: https://commitfest.postgresql.org/49/5101/
[2]: https://github.com/theory/postgres/pull/8

Commits

Make jsonpath .string() be immutable for datetimes.
- cc4fdfa411fa 17.0 landed
- cb599b9ddfcc 18.0 landed
Improve documentation and testing of jsonpath string() for datetimes.
- ed055d249df5 18.0 landed