Postgres Pro
Downloads
Home   >   mailing lists

Re: Using a serial primary key as a foreign key in a second table - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Using a serial primary key as a foreign key in a second table
Date
Msg-id 20061221174613.GA19545@wolff.to
Whole thread Raw
In response to Using a serial primary key as a foreign key in a second table  (Nathaniel <naptrel@yahoo.co.uk>)
Responses Re: Using a serial primary key as a foreign key in a second  (Patrick <flymooney@gmail.com>)
List pgsql-novice
Tree view 
On Thu, Dec 21, 2006 at 12:07:35 +0000,
  Nathaniel <naptrel@yahoo.co.uk> wrote:
>
> So, I want to add the company "Looney Tunes" (which is auto-assigned
> a company_id value), and then extract that id value so that I can use
> it in the company_id foreign key field of Bugs Bunny's person record.

The historical way to do this was with nextval and currval. In 8.2 you
also have the option of using the RETURNING clause. Looking at the
documentation, it appears you can't directly use the output of the RETURNING
clause in a subselect. You would need to save the returned value in your
app or define a set returning function to do the company update.

pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Using a serial primary key as a foreign key in a second table
Next
From:
Date:
Subject: Re: Using a serial primary key as a foreign key in a second table