Subject Re: [Firebird-Architect] for discussion Transient Data Set
Author Dmitry Yemanov
"Jim Starkey" <jas@...> wrote:
>
> I would like to see the mechanism broadened so a mass insert can return
> a transient data set of what actually got stored.

Did you think of something like:

INSERT ... RETURNING <col_list> AS <tds_name>

?

It would require an explicit DROP statement to avoid resources loss which I consider a bad idea. As for unnamed transient data sets, I don't see any relationship with Ann's proposal, as it appears to be just a request level RSE.


Dmitry