09.12.2018 16:55, Mark Rotteveel wrote:
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.
Someone just needs to put his hands on it. Not me, sorry. Maybe Adriano
will be interested, after he's back. No promises about FB4 though.
Possible, but not guaranteed.
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel