Re: Index on points - Mailing list pgsql-general

From Tom Lane
Subject Re: Index on points
Date
Msg-id 19784.1285437873@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index on points  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Index on points  (A B <gentosaker@gmail.com>)
List pgsql-general
Jeff Davis <pgsql@j-davis.com> writes:
> There's no reason that there couldn't be a point <@ box operator in the
> opclass, but nobody really uses these geometric types that come with
> core postgres (at least, not that I can tell).

Actually, as of 9.0 there is a point_ops opclass for GIST, with these
indexable operators:

 >^(point,point)
 <<(point,point)
 >>(point,point)
 <^(point,point)
 ~=(point,point)
 <@(point,box)
 <@(point,polygon)
 <@(point,circle)

I agree that for any more than light-duty geometric work, you ought
to look at PostGIS.

            regards, tom lane

pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: 9.0RC1 error variable not found in subplan target lists
Next
From: Tom Lane
Date:
Subject: Re: 9.0RC1 error variable not found in subplan target lists