Problem on Geometric functions

From: Silke Trissl <trissl(at)informatik(dot)hu-berlin(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Problem on Geometric functions
Date: 2005-01-20 09:39:47
Message-ID: 41EF7C63.20607@informatik.hu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I have a table that has an attribute 'identifier', declared as integer
and an attribute 'plane_coord' defined as 'point':

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.
Is this possible to do so? I have just found a check-operator to find
out if a specified point is contained in or on a figure:

point '(1,1)' @ box '((0,0),(2,2))'
(on http://www.postgresql.org/docs/7.4/interactive/functions-geometry.html).

I am looking for something like

SELECT point(x,y)
FROM reference.coord_test
WHERE point(x,y) € box '((0,0), (2,2))';

Has anyone experience with that?

Regards,

Silke

By the way, I am using PostGreSQL 7.4.1

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrei Bintintan 2005-01-20 09:41:41 Re: SQL timestamp to date cast
Previous Message Michael Fuhr 2005-01-20 09:33:31 Re: SQL timestamp to date cast