Postgres Pro
Downloads
Home   >   mailing lists

Thread: RETURNING clause in 8.2

RETURNING clause in 8.2

From
"Brandon Metcalf"
Date:
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.

Thanks.

--
Brandon

Re: RETURNING clause in 8.2

From
"Scott Marlowe"
Date:
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