Re: re-using RETURNING

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: re-using RETURNING
Date: 2009-11-12 14:51:52
Message-ID: 4AFC2108.7030404@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2009-11-12 14:58:54 Re: DB Restart
Previous Message Scott Marlowe 2009-11-12 14:17:40 Re: "duplicate key violates unique constraint" error