[postgis-users] finding duplicate value for the_geom field
Benedetto Porfidia
benedetto.porfidia at apat.it
Tue May 27 05:35:49 PDT 2008
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
>
More information about the postgis-users
mailing list