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