> "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