[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