Thread: Postgres Global Variables

I've been asked to port a Sybase database to Postgres in order to do an
initial checkout of Postgres' capabilities.  I've been successful for the
most part, but have run into a problem with the triggers.  The triggers
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.

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.

            regards, tom lane

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 #