[postgis-users] LWGEOM_gist_joinsel called with incorrect join type

Arnaud Lesauvage thewild at freesurf.fr
Mon Jun 26 02:38:15 PDT 2006


Hi all !

I get this notice when running a query :

NOTICE : LWGEOM_gist_joinsel called with incorrect join type

What does it mean, and what does it imply ?
Here is the query I am running :

SELECT r.*
   FROM codata.sites AS s
   INNER JOIN codata.releves_france AS r ON
(s.codesite=r.codesite AND s.type<>'Centre Commercial' AND 
s.type<>'Lieu Passage' AND estcarto ILIKE 'oui')
   LEFT JOIN codata_spatial.contours_sites AS c ON 
s.codesite=c.codesite
   WHERE NOT ((r.cellule_point && c.contour_site_geometry) AND 
Within(r.cellule_point, c.contour_site_geometry)) AND r.estnouveau>=0;

cellule_point is a geometry column of type POINT, and 
contour_site_geometry is a geometry column of type POLYGON.

Thanks for your help !

Regards
--
Arnaud




More information about the postgis-users mailing list