On Sep 28, 2011, at 7:19, salah jubeh 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 * FROM a NATURAL JOIN b; Michael Glaesemann grzm seespotcode net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
