Re: 8.2: select from an INSERT returning? - Mailing list pgsql-general

From Tom Lane
Subject Re: 8.2: select from an INSERT returning?
Date
Msg-id 11978.1158775681@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.2: select from an INSERT returning?  (David Fetter <david@fetter.org>)
Responses Re: 8.2: select from an INSERT returning?  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
David Fetter <david@fetter.org> writes:
> What would be involved in making INSERT/UPDATE/DELETE ... RETURNING be
> on the same level as other table-like things such as VALUES (...),
> ..., (...)?

Getting rid of their side-effects, which of course ain't happening.

The problem is the surrounding query might try to execute the command
multiple times ... or not at all ... and what would you like that to
mean?

            regards, tom lane

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: 8.2: select from an INSERT returning?
Next
From: Jeff Davis
Date:
Subject: Re: 8.2: select from an INSERT returning?