Re: Problem on Geometric functions - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Problem on Geometric functions
Date
Msg-id 20050120100444.GB37770@winnie.fuhr.org
Whole thread Raw
In response to Problem on Geometric functions  (Silke Trissl <trissl@informatik.hu-berlin.de>)
List pgsql-sql
On Thu, Jan 20, 2005 at 10:39:47AM +0100, Silke Trissl wrote:

> Table "reference.coord_test"
>    Column    |  Type   | Modifiers
> -------------+---------+-----------
>  node_name   | integer |
>  plane_coord | point   |
> 
> 
> I would like to find all points from the table that are within a square. 

Try this:

SELECT plane_coord
FROM reference.coord_test
WHERE plane_coord @ box'((0,0), (2,2))';

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: SQL timestamp to date cast
Next
From: Mihail Nasedkin
Date:
Subject: OID's