contains function

From: "Frances Collier" <fcollier(at)preparedresponse(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: contains function
Date: 2005-10-05 20:06:37
Message-ID: 20051005200642.93E69DA29A@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-10-05 20:33:16 nice pgsql article by person who is biased toward oracle...
Previous Message operationsengineer1 2005-10-05 16:23:56 Re: Moving from MySQL