|Subject||Returning generated key was Re: [Firebird-Architect] Re: Indexed Views|
> > What gets returned for a mass insert?Why? Why cannot one use
> It should generate an error.
INSERT INTO myTable(id, name)
SELECT gen_id(myGen, 1), name FROM (
SELECT DISTINCT name FROM students)
The only problem is to correctly describe it in
isc_dsql_describe_bind, so the result set is returned.
I think the answer should come from developers: if there is clean way
to implement handling of INSERT that returns result set, not a
singleton result, we can consider it. If implementing it would require
some dirty hack in the engine, we wait till better times come.