Retrieve Number of rows to be DELETEd

From: "Matthew V(dot)" < <linux4us(at)earthlink(dot)net>>
To: pgsql-general(at)postgresql(dot)org
Subject: Retrieve Number of rows to be DELETEd
Date: 2002-11-17 18:16:59
Message-ID: v2RB9.7628$aB1.6194@nwrddc02.gnilink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using ECPG and embedded SQL. In the C interface, there is a
PQcmdTuples() command which returns the number of rows affected by an SQL
statement. In embedded SQL, other than doing a SELECT count(*) first, is
there a way to get the number of rows that may be/were affected by a
delete or update?

Thanks,
--
Matthew Vanecek
perl -e 'print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
********************************************************************************
For 93 million miles, there is nothing between the sun and my shadow except me.
I'm always getting in the way of something...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben-Nes Michael 2002-11-17 19:05:11 initdb: he_IL is not a valid backend encoding name
Previous Message Patrick Welche 2002-11-17 18:09:39 Re: running query