Re: JSON Path and GIN Questions - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: JSON Path and GIN Questions
Date
Msg-id B5F73DF7-A0CF-4EA2-AF5D-800BFEA67D47@justatheory.com
Whole thread Raw
In response to Re: JSON Path and GIN Questions  (Erik Rijkers <er@xs4all.nl>)
Responses Re: JSON Path and GIN Questions
List pgsql-hackers
On Sep 15, 2023, at 23:59, Erik Rijkers <er@xs4all.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
JSONthat can be unexpected to those not in the fullness of Knowledge of the manual. Yes, this too would be good to
explainin 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
suchcomparisons? 

Thanks,

David


Attachment

pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: JSON Path and GIN Questions
Next
From: "David E. Wheeler"
Date:
Subject: Re: JSON Path and GIN Questions