The @, and other operators such as &&, work on the bounding boxes of geometries. The st_xxx functions additionally do calculations using the actual geometries themselves...

 -Josh

Frank Durstewitz 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

Reply via email to