On 28 September 2011 13:19, salah jubeh <s_ju...@yahoo.com> wrote: > > Hello, > > I have two views both contain identical column names , order and types > except the primary keys. I want to match these two views - return the pk > pair of the rows which match from these views - by comparing all the column > values. I want to write a pgplsql function to do this Job by iterating > through all the coloumns and compare the values. > > Is there another way to do that ?
SELECT a.pk1, a.pk2 FROM view1 AS b INNER JOIN view2 AS b ON (a.pk1 = b.pk1 AND a.pk2 = b.pk2 AND a.col1 = b.col1 AND a.col2=b.col2); -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
