Detecting whether a point is in a box.

From: HST <helenst(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Detecting whether a point is in a box.
Date: 2007-08-26 18:30:09
Message-ID: 1188153009.048263.161960@50g2000hsm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-26 18:55:00 Re: simple query runs 26 seconds
Previous Message Markus Schiltknecht 2007-08-26 17:04:22 Re: Geographic High-Availability/Replication