From: Adrian Klaver <aklaver@comcast.net>
To: pgsql-sql@postgresql.org
Cc: Jonah H. Harris <jonah.harris@gmail.com>
Cc: chrisj <chrisj.wood@sympatico.ca>
Subject: Re: can a insert with a returning clause be subquery ?
Date: Sat, 2 Feb 2008 16:40:55 -0800
Message-ID: <200802021640.56174.aklaver@comcast.net> (raw)
In-Reply-To: <36e682920802021612w5b04ca7dk80925b913f4b7261@mail.gmail.com>
References: <15248628.post@talk.nabble.com>
<36e682920802021612w5b04ca7dk80925b913f4b7261@mail.gmail.com>
On Saturday 02 February 2008 4:12 pm, Jonah H. Harris wrote:
> On Feb 2, 2008 6:22 PM, chrisj <chrisj.wood@sympatico.ca> wrote:
> > I know I could do this easily with a stored proc,
> > but it seems like an obvious use of the returning clause
> >
> > Am I missing some syntax error
>
> Nope, you're not missing anything. When I initially wrote this for
> Postgres, it didn't support all cases; including the one you're
> running into. It's not extremely difficult to extend, but as there
> are so few people asking for this functionality, no one has found it
> important enough to warrant extension. Perhaps I'll get to it for
> 8.4.
Would this be a variation of this item from the TODO:
* Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause
http://archives.postgresql.org/pgsql-general/2006-09/msg00803.phphttp://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php
--
Adrian Klaver
aklaver@comcast.net
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: aklaver@comcast.net, jonah.harris@gmail.com, chrisj.wood@sympatico.ca
Subject: Re: can a insert with a returning clause be subquery ?
In-Reply-To: <200802021640.56174.aklaver@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox