[postgis-users] Diff. Between 2 tables

[Francois Hugues]

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-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] De la part de Hemin Tofiq
Envoyé : jeudi 7 juin 2012 09:16
À : postgis-users at 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 at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users