PL/pgsql UPDATE status

Started by Richard Embersonabout 24 years ago2 messagesgeneral

emberson@phc.net

about 24 years ago

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

Thanks.

Richard

tgl@sss.pgh.pa.us

about 24 years ago

In reply to: Richard Emberson (#1)

Re: PL/pgsql UPDATE status

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