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

Frank Durstewitz frank.durstewitz at emporis.com
Tue Apr 22 21:44:55 PDT 2008


Thanks Josh and Paul for the clarification.

Best regards, Frank

PS: Yesterday, before i asked, i read the manual, but somehow i had not 
realized that the operators work with boundingbox, while the ST_ 
functions work with the geometry. Sorry for the noise...

Frank Durstewitz am 22.04.2008 17:36:
> 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
>   
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3281 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080423/84f8c00e/attachment.bin>


More information about the postgis-users mailing list