RE: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL

Hello Vijaykumar ,

For SQL Server , when we execute queries using ExecuteNonQuery , InternalRowsAffected is set by default .
Using diagnostics we have to collect and return explicitly for further work flow .

So is there any out-of-box equivalent in PostgreSQL ?

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: Vijaykumar Jain<mailto:vijaykumarjain(dot)github(at)gmail(dot)com>
Sent: 29 July 2021 17:56
To: Avadhut Narayan Joshi<mailto:AJoshi7(at)sensiaglobal(dot)com>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org<mailto:pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL

On Thu, Jul 29, 2021, 5:52 PM Avadhut Narayan Joshi <AJoshi7(at)sensiaglobal(dot)com<mailto:AJoshi7(at)sensiaglobal(dot)com>> wrote:
Hello Experts ,

For SQL Server , when executing queries we get value in InternalRowsAffected corresponding to row affected .
https://www.postgresql.org/docs/current/plpgsql-statements.html<https://urldefense.com/v3/__https:/www.postgresql.org/docs/current/plpgsql-statements.html__;!!JhrIYaSK6lFZ!6h6-A69ijJ0s6oIjxYprJA_cnfWrG3BW-z3RUr4SDDOS2gVt_RyCvNONATdboWIkjZ4$>

Have a look at `get diagnostics` at 42.5.5 section.