Message-ID: <41EF7C63.20607@informatik.hu-berlin.de>
Date: Thu, 20 Jan 2005 10:39:47 +0100
From: Silke Trissl <trissl@informatik.hu-berlin.de>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.4) Gecko/20030624
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Problem on Geometric functions
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: quoted-printable

Hello,

I have a table that has an attribute 'identifier', declared as integer=20
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=20
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.htm=
l).

I am looking for something like

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

Has anyone experience with that?

Regards,

Silke

By the way, I am using PostGreSQL 7.4.1