[postgis-users] What does this error mean, and how can I avoid it?

Stephen Woodbridge woodbri at swoodbridge.com
Thu Jan 3 07:53:43 PST 2008


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



More information about the postgis-users mailing list