Exposed icon indicating copy to clipboard operation
Exposed copied to clipboard

Published 20 hours ago • verified publisher icon JetBrains

UPDATE..RETURNING support

Open jonnyzzz opened this issue 7 years ago • 8 comments

It is possible to have updated rows back from a database. Let's support the syntax in Exposed too. Right now UpdateStatement return Int and thus isolates a possible ResultSet

Example reference from PostgreSQL https://www.postgresql.org/docs/9.5/static/sql-update.html

jonnyzzz avatar Jul 26 '18 16:07 jonnyzzz

Are there other databases (besides PostgreSQL) which support returning affected rows with UPDATE?

Tapac avatar Jul 30 '18 09:07 Tapac

Oracle should support it too.

pedro-carneiro avatar Mar 27 '19 21:03 pedro-carneiro

Hey, this is a very important feature for my project. Is there any chance of upstream support?

swistaczek avatar Apr 15 '19 12:04 swistaczek

Hey, this is a very important feature for my project. Is there any chance of upstream support?

Same

CommanderTvis avatar May 06 '20 13:05 CommanderTvis

+1

pablo-silverback avatar Jun 04 '21 00:06 pablo-silverback

+1 (6 months later)

pablo-silverback avatar Dec 03 '21 19:12 pablo-silverback

+1!

emise avatar Sep 14 '22 00:09 emise

+1

cpoyatos1 avatar Sep 04 '23 22:09 cpoyatos1

There are some UPDATE RETURNING code snippets in this duplicate: https://github.com/JetBrains/Exposed/issues/1271.

vkopichenko avatar Apr 03 '24 15:04 vkopichenko

+1

chskela avatar Apr 04 '24 19:04 chskela

+1

cantaylancapraz avatar Apr 09 '24 06:04 cantaylancapraz