Re: JSON Path and GIN Questions

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: Erik Rijkers <er(at)xs4all(dot)nl>
Cc: Erik Wienhold <ewie(at)ewie(dot)name>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: JSON Path and GIN Questions
Date: 2023-09-16 20:19:23
Message-ID: B5F73DF7-A0CF-4EA2-AF5D-800BFEA67D47@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sep 15, 2023, at 23:59, Erik Rijkers <er(at)xs4all(dot)nl> wrote:

> movie @? '$ ?($.year >= 2023)'
>
> I believe it is indeed not possible to have such a unequality-search use the GIN index. It is another weakness of JSON that can be unexpected to those not in the fullness of Knowledge of the manual. Yes, this too would be good to explain in the doc where JSON indexes are explained.

Is that a limitation of GIN indexes in general? Or could there be opclass improvements in the future that would enable such comparisons?

Thanks,

David

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2023-09-16 20:26:07 Re: JSON Path and GIN Questions
Previous Message David E. Wheeler 2023-09-16 17:43:47 Re: JSON Path and GIN Questions