Re: [OSM-dev] [Talk-us] tools for analysis of road networks?

2012-12-05 Thread Paul Norman
(cc'ing dev@ instead) hstore supports GiST and GIN indexes and these support only the @, ?, ? and ?| operators. ? and ?| are essentially equivalent to hstore ? 'a' AND hstore ? 'b' or the same with OR. If there is some hstore value that you use a lot for complicated queries where you need

Re: [OSM-dev] [Talk-us] tools for analysis of road networks?

2012-12-05 Thread Martijn van Exel
On Wed, Dec 5, 2012 at 3:07 PM, Paul Norman penor...@mac.com wrote: [..] If there is some hstore value that you use a lot for complicated queries where you need to use the - operator it’s possible to index that specifically. I think you can use btree or hash indexes that support