2017-01-10 5:59 GMT+01:00 Peter Eisentraut <peter.eisentr...@2ndquadrant.com
> On 1/7/17 6:39 AM, Pavel Stehule wrote:
> > ROW_COUNT .. shortcut for GET DIAGNOSTICS row_count = ROW_COUNT.
> I don't see the point.
A check how much rows was impacted by query is relative often task. So we
can do this task more user friendly.
Second motivation - ROW_COUNT is working for static and for dynamic SQL -
it can be partial replace of FOUND variable.
But now, when I am thinking about it - it can be strange for some users
too. Pretty often we use implicit LIMIT for query execution. So ROW_COUNT
can be probably different than users expecting.
> Peter Eisentraut http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services