Re: matching rows differing only by fkey,pkey - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: matching rows differing only by fkey,pkey
Date
Msg-id 20040622172704.GA19163@wolff.to
Whole thread Raw
In response to matching rows differing only by fkey,pkey  ("Matthew Nuzum" <matt@followers.net>)
Responses Re: matching rows differing only by fkey,pkey  ("Matthew Nuzum" <matt@followers.net>)
List pgsql-sql
On Tue, Jun 22, 2004 at 12:34:35 -0400, Matthew Nuzum <matt@followers.net> wrote:
> Any ideas? If someone has an alternate method of achieving the same result
> I'd be excited to hear about it.

A more precise formulation of what exactly you are doing might be helpful.
From your description it sounds like you should already know the primary
key of the row you are copying and can use currval to get the id of the
row just inserted. I get the impression that you are manually using these
values instead of having a script do it. But it should be easy to write
a script that does this for you.


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: matching rows differing only by fkey,pkey
Next
From: "Matthew Nuzum"
Date:
Subject: Re: matching rows differing only by fkey,pkey