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

Reply via email to