Re: index on a box - Mailing list pgsql-general

From Tom Lane
Subject Re: index on a box
Date
Msg-id 22738.993158503@sss.pgh.pa.us
Whole thread Raw
In response to Re: index on a box  (Dustin Sallings <dustin+postgres@spy.net>)
Responses Re: index on a box  (Dustin Sallings <dustin+postgres@spy.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Thalis A. Kalfigopoulos"
Date:
Subject: strange way to crash
Next
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Pl/pgsql function fails when false