Re: Index on points

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