X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C55FAD1D3DC for ; Tue, 17 Feb 2004 19:02:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 88877-08 for ; Tue, 17 Feb 2004 15:02:14 -0400 (AST) Received: from mx5.kent.ac.uk (mx5.ukc.ac.uk [129.12.21.36]) by svr1.postgresql.org (Postfix) with ESMTP id 3BDA7D1D174 for ; Tue, 17 Feb 2004 15:02:11 -0400 (AST) Received: from pelican.ukc.ac.uk ([129.12.200.26]) by mx5.kent.ac.uk with esmtp (Exim 4.24) id 1AtATg-0003aJ-VA for pgsql-sql@postgresql.org; Tue, 17 Feb 2004 19:01:52 +0000 Received: from dhcp669b.ukc.ac.uk ([129.12.102.155] helo=PCL3P040) by pelican.ukc.ac.uk with smtp (Exim 4.22) id 1AtATf-000722-I3 for pgsql-sql@postgresql.org; Tue, 17 Feb 2004 19:01:51 +0000 Message-ID: <006501c3f588$807b56b0$9b660c81@ad.kent.ac.uk> From: "David" To: Subject: searching polygons Date: Tue, 17 Feb 2004 19:01:51 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-UKC-Mail-System: No virus detected X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/315 X-Sequence-Number: 17005 What query would i have to use to search for an item using a polygon as a parameter? (i.e a very large polygon that would identify smaller polygons within it) ideally i would like to give postgresq a series of co-ordinates and then have it return all those results whose polygons fall into that set of co-ordinates, is this possible? at the moment all i can think of is select * from species where location between '(0,0)' and '(1000,0)' and '(0, 1000)' and '(1000; 1000)'; I think im way off, any suggestions? Cheers Dave