[postgis-users] Strange behaviour of = operator

[Steffen Macke]

Hello All,

Is the "=" operator only evaluating the bounding boxes of geometries?

The following statement returns true:

select GeometryFromText('MULTIPOLYGON(((1 1,1 0,0 0, 1 1)))') =
GeometryFromText('MULTIPOLYGON(((1 1, 0 0,0 1,1 1)))');

I know that equals() returns better results, but "=" seems to be
involved queries like

select distinct the_geom from test

Is it possible to use a distinct query that uses a better comparison
function/operator like equals()?

BTW the "=" operator is not mentioned in the PostGIS Manual.

I'm using PostGIS 1.1.1 on Windows.

Regards,

Steffen