[postgis-users] Difference between @ and ST_WITHIN/ST_CONTAINS
Josh Livni
josh at umbrellaconsulting.com
Tue Apr 22 09:36:18 PDT 2008
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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
More information about the postgis-users
mailing list