May I ask whether this suggestion has been considered being added to SQlite?
----- Original Message ----- From: Clemens Ladisch <clem...@ladisch.de> To: sqlite-users@mailinglists.sqlite.org <sqlite-users@mailinglists.sqlite.org> Sent: Friday, June 8, 2018, 08:25:25 Subject: [sqlite] Feature suggestion / requesst Hick Gunter wrote: >> I've encountered a feature that I think would be awesome: >> https://www.postgresql.org/docs/9.3/static/dml-returning.html >> Example: INSERT INTO blah (this, that, another) VALUES (x, y, z) RETURNING >> id; > What does this do if the INSERT creates multiple rows? It returns multiple rows. (Also useful with UPDATE, DELETE.) > What about inserts generated from trigger programs? The same as a SELECT in a trigger program. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users