Subject Re: [IB-Architect] Insert Returning
Author Bill Karwin
Ann Harrison wrote:
> Fine. But how would you expect this statment to behave?
>
> insert into <table> (<col list>)
> select <val list> from <select expression>
> returning <val list>
> into <var list>

I guess one would have to declare a cursor for this case, and iterate
through the cursor to fetch all the results. No matter how wacky and it
is to create a cursor for an INSERT statement in the context of SQL.

Bill Karwin