Subject | Re: [firebird-support] Insert with returning pk |
---|---|
Author | Mark Rotteveel |
Post date | 2018-08-27T19:59:14Z |
On 2018-08-27 21:29, hugo.larson@... [firebird-support] wrote:
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
> Is it possible to return PK of a table insert without knowing the PKThere is no way to do that. In the passed, I I have proposed RETURNING *
> colums name?
> INSERT INTO TABLE1 (NAME) VALUES('TESTDATA') 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