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. Regards Pavel > > -- > Peter Eisentraut http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services >
