Fw: Re: [postgis-users] Re: Comparing Geometries with Different SRIDs

Charlie Savage cfis at savagexi.com
Sun Sep 28 13:11:15 PDT 2008


> ST_equals(null,null);
> returns null
>  
> ST_equals(geometryfromtext('POINT(0 0)',null);
> returns null
> 
> I suggest that ST_equals() on mixed SRID geometries, should
> return a null, just like a null geometry does.
>  
> I think this is the most consistent approach when the
> result is actually unknown, and therefore a result of either true or
> false is inappropriate. 

I'm fine with this approach, its certainly better than throwing an error.

Charlie
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3237 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080928/63d1ae37/attachment.bin>


More information about the postgis-users mailing list