Re: index on a box

Dustin Sallings <dustin+postgres(at)spy(dot)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