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

[Flavio Perri]

Flavio Perri

postgis-users-bounces at postgis.refractions.net wrote on 22/05/2007 20.01.55:

> 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.
>
Thanks for the answer, Mark. That NOTICE is very annoying. How can I delete
it? And also, if I want all lines "inside" the ellipse, is it the "&&
operator condition" enough?