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
thesetwo views - return the pk pair of the rows which match from these views - by comparing all the column values. I
wantto 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