Problem GIN indexing json array elements in postgres
Budget: $10 – $30 USD
Hello there,
we have a json field in postgres table. we would like to create index of json array element
we are able to create index like this
CREATE INDEX indextopics ON bnb_transactions USING gin ( (transactions -> 'logs') jsonb_path_ops)
but want to index array elements in 'topics' key in jsonb_path_ops
json format attached to this project. please check it
only bit if you know the solution of how to index array elements of "topics"
thank you
example:
we have a json field in postgres table. we would like to create index of json array element
we are able to create index like this
CREATE INDEX indextopics ON bnb_transactions USING gin ( (transactions -> 'logs') jsonb_path_ops)
but want to index array elements in 'topics' key in jsonb_path_ops
json format attached to this project. please check it
only bit if you know the solution of how to index array elements of "topics"
thank you
example: