Re: Postgres Global Variables

Tom Lane wrote:
> shm(at)daimlerchrysler(dot)com writes:
> > make use of a Sybase global variable called @@rowcount. @@rowcount
> > represents the number of rows affected by the most recent data modification
> > operation (inserts, deletes and/or updates).
>
> > Is there an equivalent in Postgres? Thanks much for the help.
>
> I think the libpq function PQcmdTuples() does what you want, although
> it's possible Sybase's behavior differs in some details.

In the 7.1 tree are changes from Philip Warner, gaining
access to this info from PL/pgSQL (new GET DIAGNOSTICS
command). I think this is closer to what he's looking for.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #