Re: Postgres Global Variables
Re: Postgres Global Variables
От:
Jan Wieck <janwieck@Yahoo.com>
Дата:
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 #
Re: Postgres Global Variables
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
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
Postgres Global Variables
От:
shm@daimlerchrysler.com
Дата:
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.
