From: Silke Trissl <trissl@informatik.hu-berlin.de>
To: pgsql-sql@postgresql.org
Subject: Problem on Geometric functions
Date: Thu, 20 Jan 2005 10:39:47 +0100
Message-ID: <41EF7C63.20607@informatik.hu-berlin.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: trissl@informatik.hu-berlin.de
Subject: Re: Problem on Geometric functions
In-Reply-To: <41EF7C63.20607@informatik.hu-berlin.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox