Question: SQL Server's SET NOCOUNT ON Postgresql equivalent

Question

SQL Server's SET NOCOUNT ON Postgresql equivalent

Answers 0
Added at 2016-12-28 16:12
Tags
Question

I've to help migrating a SQL Server 2008 database to a PostgreSQL 9.4.10 one. The original querys have SET NOCOUNT ON and SET NOCOUNT OFF several times, and I can't change this fact so ignoring the number of rows affected isn't a solution. That's why I need to find an equivalent to this statement, but all I can find are really old posts where they say I should ignore the result. Any ideas? Thanks.

EDIT: these SET NOCOUNTare inside a stored procedure that goes like this:

CREATE PROCEDURE [procedureName]
Declares

--Variables 

WITH ENCRYPTION
AS
SET NOCOUNT ON

--Procedure's code

SET NOCOUNT OFF
GO

As I've said this code isn't mine, so I can't post any of it more than the source of my doubt.

Answers
Source Show
◀ Wstecz