Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part

David E. Wheeler <david@justatheory.com>

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

To: Florents Tselai <florents.tselai@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter@eisentraut.org>, Robert Haas <robertmhaas@gmail.com>, Alexander Korotkov <aekorotkov@gmail.com>, pgsql-hackers <pgsql-hackers@lists.postgresql.org>, Andrew Dunstan <andrew@dunslane.net>

Date: 2025-06-14T15:08:07Z

Lists: pgsql-hackers

Attachments

v9-0001-Rename-jsonpath-method-arg-tokens.patch (application/octet-stream) patch v9-0001
v9-0002-Add-additional-jsonpath-string-methods.patch (application/octet-stream) patch v9-0002
(unnamed) (text/plain)

On Jun 4, 2025, at 11:27, David E. Wheeler <david@justatheory.com> wrote:

> And these should fix the CI failure. I also ran pgindent.

Here’s a quick rebase. I think it’s ready for committer review, but since I’ve poked at it quite a bit myself, I updated the Commitfest item [1] to “Needs Review”.

Best,

David

[1]: https://commitfest.postgresql.org/patch/5270/

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add additional jsonpath string methods
- bd4f879a9cdd 19 (unreleased) landed
Rename jsonpath method arg tokens
- a35c9d524ed0 19 (unreleased) landed
Fix transient memory leakage in jsonpath evaluation.
- 5a2043bf7131 19 (unreleased) cited
Make jsonpath .string() be immutable for datetimes.
- cb599b9ddfcc 18.0 cited