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