[postgis-users] Comparing Geometries with Different SRIDs

Charlie Savage cfis at savagexi.com
Sat Sep 27 14:31:19 PDT 2008



> 
> I guess its because at some point to determine uniqueness UNION has to call
> something like ST_Equals and since all the PostGIS relation functions are
> only supported for geometries with the same SRID it would fail.

Look like it:

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

ERROR:  Operation on mixed SRID geometries


> So I would say this is a limitation of design rather than a bug.

I disagree. I think ST_EQUALS should return false here, not blow up.

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/20080927/74a79816/attachment.bin>


More information about the postgis-users mailing list