Re: How to retrieve number of rows affected, in an after statement trigger? - Mailing list pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> Is it possible to retrieve information about how many rows were
> changed/inserted in a table that fired after statement trigger?

Not directly, but you can store the information from row-level
triggers and gather it at the end. See this plperl example:

http://people.planetpostgresql.org/greg/index.php?/archives/2007/05/30.html

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200707070745
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFGj30hvJuQZxSWSsgRA9iXAJ0aiS5oVbYxcY69yY0zvig4G4eBTwCdE5ON
EYV77TeTYNSRt46fsZDfkTI=
=C7mD
-----END PGP SIGNATURE-----