[postgis-users] equals and =

[Rhys Stewart]

Greetings all,

I have a relation and i am trying to remove duplicate and/or similar
geometries. I get different results when I use equals(geometry,geometry) and
geom = geom. While i expect this based on the docs, im getting back more
results when I use geom = geom than when I use the equals(geom,geom)
function.

Maybe I am mistaken as to what the differences between equals and = are?

Here are the queries:

select q.objectid,w.objectid, astext(q.the_geom),astext(w.the_geom) from
ill_second q
inner join ill_second w on q.the_geom && w.the_geom
    AND equals(q.the_geom,w.the_geom) --and q.the_geom = w.the_geom
where q.objectid <> w.objectid

and

select q.objectid,w.objectid, astext(q.the_geom),astext(w.the_geom) from
ill_second q
inner join ill_second w on q.the_geom && w.the_geom
    AND q.the_geom = w.the_geom
where q.objectid <> w.objectid

Version info:
"PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"
"POSTGIS="1.3.2" GEOS="3.0.0rc4-CAPI-1.3.3" PROJ="Rel. 4.5.0, 22 Oct 2006"
USE_STATS"




Thanks,
Rhys
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080423/f940e806/attachment.html>