Subject | Re: [IB-Architect] Insert Returning |
---|---|
Author | Bill Karwin |
Post date | 2000-07-18T06:58:30Z |
Ann Harrison wrote:
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
> Fine. But how would you expect this statment to behave?I guess one would have to declare a cursor for this case, and iterate
>
> insert into <table> (<col list>)
> select <val list> from <select expression>
> returning <val list>
> into <var list>
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