[postgis-users] finding duplicate value for the_geom field

[Benedetto Porfidia]

build a gist index on your table and run something like this:

SELECT a.gid,b.gid,a.the_geom, b.the_geom
FROM my_table as a,my_table as b
WHERE  a.the_geom && b.the_geom and a.gid<>b.gid;

Antonio Di Marco ha scritto:
> Hi, how can I find duplicate value in a PostgreSQL table for the 
> geometry field (the_geom)
> Thanks a lot
> 
> Antonio
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>