From: | mike <mike(at)thegodshalls(dot)com> |
---|---|
To: | Frances Collier <fcollier(at)preparedresponse(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: contains function |
Date: | 2005-10-06 02:38:52 |
Message-ID: | 1128566332.26586.2.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-10-06 05:11:05 | Re: contains function |
Previous Message | John DeSoi | 2005-10-06 02:29:32 | Re: PL/pgSQL - Sytax Error near $1 ? |