searching polygons - Mailing list pgsql-sql

From David
Subject searching polygons
Date
Msg-id 006501c3f588$807b56b0$9b660c81@ad.kent.ac.uk
Whole thread Raw
Responses Re: searching polygons  (elein <elein@varlena.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Date Foo.
Next
From: Mark Tabash
Date:
Subject: create function atof?