Re: RETURNING clause in 8.2 - Mailing list pgsql-general

From Scott Marlowe
Subject Re: RETURNING clause in 8.2
Date
Msg-id dcc563d10806181306x5fbe1a67nefad08ded74b57d1@mail.gmail.com
Whole thread Raw
In response to RETURNING clause in 8.2  ("Brandon Metcalf" <bmetcalf@nortel.com>)
List pgsql-general
On Wed, Jun 18, 2008 at 1:32 PM, Brandon Metcalf <bmetcalf@nortel.com> wrote:
> I see that 8.2 has added a RETURNING clause option to the INSERT
> command.  Is there anyway to achieve the same thing in versions prior
> to 8.2?  Specifically, I need to return a default sequence number
> generated from an INSERT.

Not really the same.  You can use currval('seqname') in versions before 8.2

pgsql-general by date:

Previous
From: "Brandon Metcalf"
Date:
Subject: RETURNING clause in 8.2
Next
From: "Scott Marlowe"
Date:
Subject: Re: Easiest way to copy table from one db to another?