Re: [HACKERS] Question on "box @> point" using GiST index on boxes

2012-10-03 Thread Tom Lane
Ralf Rantzau writes: > I would like to test the containment of a point against many boxes. > I did not find a way to express "box @> point" in straightforward way such > that the GiST index on the boxes is exploited. Yeah, that operator is not in any GiST opclass, as you can easily verify with a

[HACKERS] Question on "box @> point" using GiST index on boxes

2012-10-03 Thread Ralf Rantzau
Hello, I would like to test the containment of a point against many boxes. I did not find a way to express "box @> point" in straightforward way such that the GiST index on the boxes is exploited. The only way to use a point directly is to turn the box into a polygon. Is it a missing feature? T