Back in 2012 I created CORE-3808 to request support for RETURNING *,
which should - equivalent to SELECT * - return all columns instead of
having to manually include all columns in the returning clause.
The primary use case for me would be to more easily support the JDBC
getGeneratedKeys functionality, and with better performance than the
current implementation because it would avoid roundtrips to query the
metadata tables. I assume this would also be useful for other drivers or
frameworks that require similar functionality.
For example PostgreSQL already has this (see
https://www.postgresql.org/docs/current/sql-insert.html).
Could this feature be given more priority please? If possible, for
inclusion in Firebird 4.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
