29.11.2017 11:51, Jiří Činčura wrote:
The second update did not update any records, yet it still returns one row in result with NULL value. Shouldn't it return empty result set?
"Update returning" is the same as "execute procedure". It returns fixed set of values, not a result set.
-- WBR, SD. ------------------------------------------------------------------------------ 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