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 ?
Thanks in advance
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 ?
Thanks in advance
