Re: [GENERAL] Index using in jsonb query

query: select field1,field2 from datatable where (jsonfield#>>'{path1,path2}')::numeric = 1000; Definitely, I didn't find a way to optimize a query that checks a range in a json subfield. On 3/11/2017 3:55 PM, SuperCiccio wrote: Is there a way to make the following query use some sort

[GENERAL] Index using in jsonb query

Is there a way to make the following query use some sort of indexing? select field1,field2 from datatable where (jsonfield#>>'{path1,path2}')::numeric < 1000; Thanks