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

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: Florents Tselai <florents(dot)tselai(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Peter Eisentraut <peter(at)eisentraut(dot)org>
Subject: Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part
Date: 2025-05-22 18:08:02
Message-ID: 33601D2F-6BCA-4E6C-AC97-668A739356F8@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On May 22, 2025, at 12:38, Florents Tselai <florents(dot)tselai(at)gmail(dot)com> wrote:

> In my experience timestamp related stuff from jsonb documents end up in a generated column,
> and are indexed & queried there.

Have you seen this in the wild using the _tz functions? I wouldn’t think they were indexable, given the volatility.

D

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2025-05-22 18:52:21 Re: Statistics Import and Export
Previous Message Matthias van de Meent 2025-05-22 17:57:57 Re: Adding skip scan (including MDAM style range skip scan) to nbtree