On 3/11/2017 3:55 PM, SuperCiccio wrote:
> 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