[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