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/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
