Hello, I'm not sure I understand the whole thing but in a basic way and if your table have a primary key a self join should help you :
select a.* from mytable a, mytable b where a.id = b.id and (a.attr1 != b.attr1 or a.attr2 != b.attr2) The attribut can be a geometry or anything else. Hugues -----Message d'origine----- De : postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] De la part de Hemin Tofiq Envoyé : jeudi 7 juin 2012 09:16 À : postgis-users@postgis.refractions.net Objet : [postgis-users] Diff. Between 2 tables Hi, I would like to ask if there is a way to compare (find the difference) between 2 tables? Updated geometries or attributes), i.e. An sql som returnes the rows that are updated. Thanks in advance, Hemin -- View this message in context: http://postgis.17.n6.nabble.com/Diff-Between-2-tables-tp4998062.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users