Home > mailing lists

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

From	SuperCiccio
Subject	[GENERAL] Index using in jsonb query
Date	March 12, 2017 05:55:43
Msg-id	3c94dbd2-9efe-438c-cd25-b00af8f09010@yahoo.it Whole thread Raw
Responses	Re: [GENERAL] Index using in jsonb query
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Alexander Farber
Date: 11 March 2017, 19:09:23
Subject: Re: [GENERAL] CHECK for 2 FKs to be non equal

From: John R Pierce
Date: 12 March 2017, 07:20:40
Subject: Re: [GENERAL] Index using in jsonb query

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

Previous

Next