Re: New operators and class for jsonb with gin indexing

Luka Zivkovic <lukazivkovic58(at)gmail(dot)com> writes:
> I am having problems applying gin indexing to my new operator class for
> type jsonb.
> I created an operator that can query(jsonb column) keys and dates where
> dates are more than, less than, equal and not equal to the one provided
> inside another jsonb.
> Because I want to make it use index search and not sequential search, I
> wanted to use gin indexing, but it says that i'm missing support functions.
> Did anybody try to do something like this?

There's not a whole lot of documentation about this, but there is some:

https://www.postgresql.org/docs/13/gin-extensibility.html

After reading that, I'd suggest looking into the code for gin opclass
support in various contrib modules (hstore might be a good start).

regards, tom lane