"Ann W. Harrison" <aharrison@...> wrote:

>
> What gets returned for a mass insert? Or is the RETURNING only
> allowed for a singleton insert?

In Oracle, if the RETURNING clause is bound to an array-type host variable,
then multiple row updates can return multiple values. Otherwise, a singleton
select error is generated. IMO, we also should add a singularity verb to the
underlying select to return an error in this case. I really don't think that
returning datasets from INSERT/UPDATE/DELETE is a good idea. Just think
about its usage in PSQL.


Dmitry