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-03T19:10:28Z

Lists: pgsql-hackers

Attachments

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

On Jun 3, 2025, at 15:02, David E. Wheeler <david@justatheory.com> wrote:

> Patches attached, GitHub PR here:
> 
>  https://github.com/theory/postgres/pull/12

Found a little more unnecessary code to remove. Updated patches attached.

Best,

David

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