[postgis-users] contains function

[Frances Collier]

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
statement:

 

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.421703,31.226228),(-85.440253,31.226228),

                                 (-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,

Frances

 

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