Re: re-using RETURNING - Mailing list pgsql-general

From Craig Ringer
Subject Re: re-using RETURNING
Date
Msg-id 4AFC2108.7030404@postnewspapers.com.au
Whole thread Raw
In response to re-using RETURNING  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
On 12/11/2009 9:41 PM, A. Kretschmer wrote:
> Hi,
>
> just to be sure, it is still (8.4) not possible to use RETURNING within an
> other INSERT?

Not directly, now. However, if I recall correctly in 8.4 you *CAN* use a
... RETURNING statement within an SQL function, and use the results of
that in another query.

--
Craig Ringer

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: "duplicate key violates unique constraint" error
Next
From: Richard Huxton
Date:
Subject: Re: DB Restart