Postgres Pro
Downloads
Home   >   mailing lists

RE: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL - Mailing list pgsql-sql

From Avadhut Narayan Joshi
Subject RE: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL
Date
Msg-id PH0PR18MB46088C7D5E96925E0236116D9CEB9@PH0PR18MB4608.namprd18.prod.outlook.com
Whole thread Raw
In response to Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Responses Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
List pgsql-sql
Tree view

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 for Windows 10

 

From: Vijaykumar Jain
Sent: 29 July 2021 17:56
To: Avadhut Narayan Joshi
Cc: pgsql-sql@lists.postgresql.org
Subject: Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL

 

 

On Thu, Jul 29, 2021, 5:52 PM Avadhut Narayan Joshi <AJoshi7@sensiaglobal.com> wrote:

Hello Experts ,

 

For SQL Server , when executing queries we get value in InternalRowsAffected corresponding to row affected . 

 

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

 

 

 

pgsql-sql by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL
Next
From: Vijaykumar Jain
Date:
Subject: Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL