Re: [GENERAL] Index using in jsonb query - Mailing list pgsql-general

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;

if the '{path1,path2}' part is constant, I'd think you could create an index on (jsonfield #>> '{path1,path2}')::numeric

-- 
john r pierce, recycling bits in santa cruz