geography allows comparing geographies with different spheroids

[robe]

I'm guess you are just taking the first spheroid. Something like this I feel should be illegal.

SELECT ST_Distance('SRID=4326;POINT(-71.070168 42.370024)'::geography, 'SRID=4267;POINT(-71.080168 42.370024)'::geography);

823.690428176

Just as this is illegal

SELECT ST_Distance('SRID=4326;POINT(-71.070168 42.370024)'::geometry, 'SRID=4267;POINT(-71.080168 42.370024)'::geometry);

ERROR:  Operation on two GEOMETRIES with different SRIDs

Unless you are doing some voodoo behind the scenes to change the spheroid of one.

[pramsey]

Duplicates #3202

[pramsey]

Fixed in r13826