Re: Postgres Global Variables - Mailing list pgsql-general

From Jan Wieck
Subject Re: Postgres Global Variables
Date
Msg-id 200010231019.FAA00948@jupiter.jw.home
Whole thread Raw
In response to Re: Postgres Global Variables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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 #



pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Arrays in PL/PGSQL
Next
From: Jan Wieck
Date:
Subject: Re: How does TOAST compare to other databases' mechanisms?