Обсуждение: RETURNING clause in 8.2

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

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