I am attempting to use `RETURNING` for the Postgre...
# squarelibraries
s
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.
Copy code
delete:
DELETE FROM players
WHERE id = ?
RETURNING *;
n
seems like that specific feature is still not implemented: https://github.com/AlecStrong/sql-psi/issues/173
s
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!