The operators (@, &&, etc) all work on bounding boxes. The functions all work on full geometries. It is possible for geometries to satisfy bounding box containment while not satisfying full geometric containment, hence your discrepancy.
P. On Tue, Apr 22, 2008 at 8:36 AM, Frank Durstewitz <[EMAIL PROTECTED]> wrote: > Hi, > can someone please explain, what the difference between > > WHERE ST_CONTAINS(b.geom, e.geom) > > and > > WHERE e.geom @ b.geom > > is? (b.geom are (multi-)polygons and e.geom are points) > > I expect to get the same results, but with @ i get a few more records...? > > TIA, Frank > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
