From: Jonah H. Harris <jonah.harris@gmail.com>
To: chrisj <chrisj.wood@sympatico.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: can a insert with a returning clause be subquery ?
Date: Sat, 2 Feb 2008 19:12:32 -0500
Message-ID: <36e682920802021612w5b04ca7dk80925b913f4b7261@mail.gmail.com> (raw)
In-Reply-To: <15248628.post@talk.nabble.com>
References: <15248628.post@talk.nabble.com>
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.
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/
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: jonah.harris@gmail.com, chrisj.wood@sympatico.ca
Subject: Re: can a insert with a returning clause be subquery ?
In-Reply-To: <36e682920802021612w5b04ca7dk80925b913f4b7261@mail.gmail.com>
* 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