[postgis-users] Comparing Geometries with Different SRIDs

Charlie Savage cfis at savagexi.com
Sat Sep 27 13:33:34 PDT 2008


This looks like a related issue:

select 'srid=4326;point(3 3)'::geometry
union
select 'srid=4325;point(3 3)'::geometry

ERROR:  Operation on two GEOMETRIES with different SRIDs

I find that surprising, I would expect to get a result table with two rows.

Charlie

Charlie Savage wrote:
> Here is another SRID issue that seems strange:
> 
> select 'srid=4326;polygon((0 0, 0 5, 5 5, 5 0, 0 0))'::geometry = 
> 'point(2 2)'::geometry
> 
> 
> ERROR:  Operation on two GEOMETRIES with different SRIDs
> 
> 
> Why not just return FALSE?  I can see forcing the same SRID when 
> performing operations such as unions, but if the geometries have 
> different SRID's then it seems reasonable to assume they are not 
> equivalent.
> 
> 
> Charlie
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Charlie Savage
http://cfis.savagexi.com
-------------- 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/20080927/7b95bd4e/attachment.bin>


More information about the postgis-users mailing list