[postgis-users] LWGEOM_gist_joinsel called with arguments that are not column references

[Mark Cave-Ayland]

On Tue, 2007-05-22 at 11:48 +0200, Flavio Perri wrote:
> Hello. I got this error (NOTICE:  LWGEOM_gist_joinsel called with arguments
> that are not column references ) when calling this query:
> 
> select * from pointTable a,lineTable l where point=... and
> Intersects(l.the_geom,ellipse(X(a.point_geom),Y(a.point_geom),0.010,0.005,a.direction,50))
>   and ( ellipse(X(a.point_geom),Y(a.point_geom),0.010,0.005,a.direction,50)
> && l.the_geom ) where ... ;
> 
> What's wrong with this?

Hi Flavio,

There's nothing really wrong - it's just the selectivity routine can't
calculate the selectivity of a function of a column, and so it's a
warning that the a && b clause will always be evaluated first above the
Intersects(a,b) and point = x. Depending upon your data, this may or may
not be optimal but it will still work.


Kind regards,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk