[postgis-users] Re: What does this error mean, and how can I avoid it?
Stephen Woodbridge
woodbri at swoodbridge.com
Thu Jan 3 11:51:09 PST 2008
Stephen Woodbridge wrote:
> Hi all,
>
> I ran into this last night while playing with some queries:
>
> NOTICE: LWGEOM_gist_joinsel called with arguments that are not column
> references
> CONTEXT: SQL statement "select a.file, a.name, b.name
> from canada_p.pl a, canada_p.pl b
> where expand(a.the_geom, 2/69) && b.the_geom
> and (strpos(a.name, b.name)>0 or strpos(b.name, a.name)>0)"
>
> This one is new to me. I am trying to find all records with similar
> names within about 2 miles of one another in this table.
>
> Thanks,
> -Steve
>
Posted this earlier today but it seems to be lost in the ethers.
Sorry if you get this twice.
-Steve
More information about the postgis-users
mailing list