[postgis-users] Difference between @ and ST_WITHIN/ST_CONTAINS

Paul Ramsey pramsey at cleverelephant.ca
Tue Apr 22 09:39:19 PDT 2008


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
<frank.durstewitz at emporis.com> 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