Detecting whether a point is in a box. - Mailing list pgsql-general

From HST
Subject Detecting whether a point is in a box.
Date
Msg-id 1188153009.048263.161960@50g2000hsm.googlegroups.com
Whole thread Raw
Responses Re: Detecting whether a point is in a box.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Detecting whether a point is in a box.  (hrsuprith <hrsuprith@gmail.com>)
List pgsql-general
Hello

I am trying to write a query to find all points that fall within a
given box. However, I cannot seem to find the functionality for
determining whether a point is within a box.

e.g.  select box '((0,0),(1,1))' @> point '(0.5,0.5)';

operator does not exist: box @> point

Is this operator for circles only? Is there a similar operator for
boxes? I have not been able to find it in the documentation.

Any help would be much appreciated
H


pgsql-general by date:

Previous
From: Ow Mun Heng
Date:
Subject: psql \copy command runs as a transcation?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Out of Memory - 8.2.4