Re: Number of rows affected by an update - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: Number of rows affected by an update
Date
Msg-id 3E782656.8020404@klaster.net
Whole thread Raw
In response to Number of rows affected by an update  ("David Witham" <davidw@unidial.com.au>)
List pgsql-sql
Uz.ytkownik David Witham napisa?:
> Hi,
> 
> Is there a way of capturing how many rows a select, delete or update affect from within a PL/pgSQL function?
Read Postgres documentation.
19.5.5. Obtaining result status

GET DIAGNOSTICS var_integer = ROW_COUNT;

Regards,
Tomasz Myrta



pgsql-sql by date:

Previous
From: "David Loh"
Date:
Subject: Casting with character and character varying
Next
From: "Victor Yegorov"
Date:
Subject: vacuum all but system tables