[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