[postgis-users] LWGEOM_gist_joinsel called with incorrect join type

[strk at refractions.net]

The JOIN selectivity estimator only works in INNER join contexts
in other cases it returns the default join selectivity.

--strk;

On Mon, Jun 26, 2006 at 11:38:15AM +0200, Arnaud Lesauvage wrote:
> 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
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for low technology.
  X     Keep e-mail messages readable by any computer system.
 / \    Keep it ASCII.