I don't believe postgresql recognizes "Contains". Try SELECT ... AND
wkb_geometry IN (....)
Mike
On Wed, 2005-10-05 at 13:06 -0700, Frances Collier wrote:
> 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
>
>
>
>