Horton
Menu

Re: JSON Path and GIN Questions

David E. Wheeler <david@justatheory.com>

View thread
From: "David E. Wheeler" <david@justatheory.com>
To: Erik Rijkers <er@xs4all.nl>
Cc: Erik Wienhold <ewie@ewie.name>, pgsql-hackers@lists.postgresql.org
Date: 2023-09-16T20:19:23Z
Lists: 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 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

Commits

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

  1. Doc: add a bit to indices.sgml about what is an indexable clause.