Re: PLPGSQL returning number of rows

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Nov 10, 2016 at 5:44 PM, Patrick B <patrickbakerbr@xxxxxxxxx> wrote:

Hi guys,

I'm writing a simple Plpgsql function to delete some data from different tables.

The function starts with a select, and then 2 deletes after that.

How can I return the number of rows that each delete performed?

​The pl/pgsql chapter named: "Basic Statements - Obtaining the Result Status" sounds like a good place to look...

Here's a link:

https://www.postgresql.org/docs/9.6/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS​

​David J.