Thread: PL/pgsql UPDATE status

PL/pgsql UPDATE status

From

Richard Emberson

Date:

19 February 2002, 01:23:54

Using an UPDATE statement within a PL/pgsql function is there anyway to
tell
how many rows actually got changed?

Thanks.

Richard

Re: PL/pgsql UPDATE status

From

Tom Lane

Date:

19 February 2002, 02:25:18

Richard Emberson <emberson@phc.net> writes:
> Using an UPDATE statement within a PL/pgsql function is there anyway to
> tell
> how many rows actually got changed?

See GET DIAGNOSTICS.

            regards, tom lane