[postgis-users] contains function

Frances Collier fcollier at preparedresponse.com
Wed Oct 5 14:25:46 PDT 2005

Are there any examples of using postgis that I can use for research?


My current problem is the use of the Contains function.  Here's my


Select astext(wkb_geometry), name, state

>From usroads

Where state = 'Alabama'

And name like '%Ross Clark%'

And Contains(polygon('(-85.440253,31.207678),(-85.421703,31.207678),


                                 (-85.440253,31.207678)'), wkb_geometry);


Here is the error I'm getting back:


ERROR:  function contains(polygon, geometry) does not exist

HINT:  No function matches the given name and argument types. You may need
to add explicit type casts.


I've tried numerous ways to fix this but I haven't had any luck. I'd really
appreciate any help I can get.


Thank you,



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051005/ea719223/attachment.html>

More information about the postgis-users mailing list