I am attempting to use `RETURNING` for the Postgress Dialect with SqlDelight but it doesn't seem to ...

# squarelibraries

[simon.vergauwen]

I am attempting to use RETURNING for the Postgress Dialect with SqlDelight but it doesn't seem to be working. It was added in 1.4.3 according to the release notes, https://github.com/cashapp/sqldelight/releases/tag/1.4.3. Any idea if this is possible or I am doing something wrong? The SqlDriver#execute is fixed to Unit so it seems it cannot return any value. I am using it in a simple query like this.

delete:
DELETE FROM players
WHERE id = ?
RETURNING *;

[Nikky]

seems like that specific feature is still not implemented: https://github.com/AlecStrong/sql-psi/issues/173

[Nikky]

the things that are possible should be in these samples: https://github.com/AlecStrong/sql-psi/pull/170/files#diff-05e13792e947e4e73bcf6a4391bf80f43f055ecd6a31d0070c6830f34205f970

[simon.vergauwen]

Oh okay, I see so RETURNING is possible within a query but you're not able to use RETURNING to get a result back from a query. Thanks for the references @Nikky!