Dustin Sallings <dustin+postgres@spy.net> writes:
> Around 11:08 on Jun 21, 2001, Tom Lane said:
> # If you say "SET enable_seqscan TO off", and repeat the EXPLAIN, do you
> # get an indexscan plan?
> Seq Scan on tmp (cost=100000000.00..100002500.84 rows=30434 width=92)
Drat.
> I'm not sure what you just said. :)
Never mind, it wouldn't work anyway.
The problem is that "point @ box" isn't an rtree-indexable operation.
You could use "box @ box" instead, where the lefthand box is a zero-area
box with all corners at the point of interest. Crufty, but unless you
want to go in and teach rtree about a new operator type...
regards, tom lane