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
> v
.
Regards
From: Chris Travers
To:
Cc: salah jubeh ; pgsql
Sent: Wednesday, September 28, 2011 5:09 PM
Subject: Re: [GENERAL] tubles matching
Is something like this what you are trying to do?
somedb=# create table a (a int, b text, c date);
CREATE TABLE
somedb
Is something like this what you are trying to do?
somedb=# create table a (a int, b text, c date);
CREATE TABLE
somedb=# create table b (a int, b text, c date);
CREATE TABLE
somedb=# select * from a join b using (a, b, c);
a | b | c
---+---+---
(0 rows)
somedb=# insert into a values (1, 'test',
On 28 September 2011 13: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.
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 ite
