[postgis-users] Comparing Geometries with Different SRIDs

[Mark Cave-Ayland]

Charlie Savage wrote:

> 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.

Me too. Having a function to check equality that blows up rather than 
returning a false result when two inputs are unequal seems fairly silly 
to me. Charlie, would you like to file this on the PostGIS bugtracker?


Many thanks,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063