Thread: Number of rows affected by an update

Number of rows affected by an update

From

"David Witham"

Date:

19 March 2003, 02:42:43

Hi,

Is there a way of capturing how many rows a select, delete or update affect from within a PL/pgSQL function?

Thanks,

David Witham
Unidial

Re: Number of rows affected by an update

From

Tomasz Myrta

Date:

19 March 2003, 06:11:06

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