Skip site navigation (1) Skip section navigation (2)

Re: matching rows differing only by fkey,pkey

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Matthew Nuzum <matt(at)followers(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: matching rows differing only by fkey,pkey
Date: 2004-06-22 17:27:04
Message-ID: 20040622172704.GA19163@wolff.to (view raw or flat)
Thread:
Lists: pgsql-sql
On Tue, Jun 22, 2004 at 12:34:35 -0400,
  Matthew Nuzum <matt(at)followers(dot)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.

In response to

Responses

pgsql-sql by date

Next:From: Matthew NuzumDate: 2004-06-22 17:40:03
Subject: Re: matching rows differing only by fkey,pkey
Previous:From: Richard HuxtonDate: 2004-06-22 17:16:16
Subject: Re: matching rows differing only by fkey,pkey

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group