| 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: | Whole Thread | Raw Message | 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
| 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 |