[postgis-users] within function

[Dave Potts]

I have a table with a list of places described as Geometry type POINT 
and a table loaded from a shape file,  which takes the form of target 
(ie several inscribed circles), each is encoded as a MULTIPOLYGON.  I am 
attempting to discover which point lie within within these circle.

I had assumed that something like

select place_name,gid,id,gridcode,area(the_geom) , 
within(the_geom,os_ngr) from shptbl,place_table wherein (the_geom,os_ngr) ;

would return every geometry ie os_ngr which is within the geometry  
boundries of the_geom.

Where place_name,os_ngr come from place_table and the_geom comes from 
the table shptbl.

Both geometry have the same sri, no errors are listed in the postgres 
log files.
I have assume that within covers data types of different types (ie POINT 
and MULTIPOLYGON)

Dave.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dave.potts.vcf
Type: text/x-vcard
Size: 85 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070807/36989a50/attachment.vcf>