Dmitry Yemanov wrote:

>"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.
>
>
>

No more resource loss that select ... yielding. And of course it would
have a name ... now else could you reference it?