I must say that i thinked about this in the same way as you.
And i also do not know from where i got this impression ...
I really supposed that it return resultset
regards,
Karol Bieniaszewski
-----Oryginalna wiadomość-----
From: Jiří Činčura
Sent: Wednesday, November 29, 2017 1:32 PM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] RETURNING clause returning NULL row when no
value was updated
"Update returning" is the same as "execute procedure". It returns
fixed set of values,
not a result set.
Hmm. I lived in a dream. I would argue that the i.e. "update foobar set
foo = 2 returning bar;" would return multiple rows and is allowed since
2.5. But quick test now shows that even 3.0.2 prohibits that. Not sure
where I've got that impression from.
I just can't get, at least once, helping hand from Firebird. :)
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
---
Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie
antywirusowe Avast.
https://www.avast.com/antivirus
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
