Re: Postgres Global Variables

Tom Lane wrote:
> shm@daimlerchrysler.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@Yahoo.com #