Subject Re: [firebird-support] Insert with returning pk
Author Mark Rotteveel
On 2018-08-27 21:29, hugo.larson@... [firebird-support] wrote:
> Is it possible to return PK of a table insert without knowing the PK
> colums name?
> INSERT INTO TABLE1 (NAME) VALUES('TESTDATA') RETURNING ....

There is no way to do that. In the passed, I I have proposed RETURNING *
which would return all columns (PostgreSQL has this), see
http://tracker.firebirdsql.org/browse/CORE-3808, but that isn't planned
for any version yet.

Mark