Subject Re: [IB-Architect] Insert Returning
Author Jan Mikkelsen
Ann Harrison <harrison@...> wrote:
>Any thoughts?

I had decided not to get involved in any of these discussions until the
source was actually released, but here is a quick thought:

Why shouldn't an insert statement be allowed as a query specification? The
specification of the set to be returned is a simple projection using select.

For example:

select * from insert into <table> (<col list>) values (<val list>);

The syntax could then be extended over time:

insert into t2 (f1) select f1 from insert into t1 (f1, f2) values (1, 2);

Seems much nicer than putting things like "returning" into the language.
Something similar could be done with delete and update, if appropriate.

Anyway, I'll be back when the source is released.


Jan Mikkelsen