Retrieve Number of rows to be DELETEd

From: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Cc: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
Subject: Retrieve Number of rows to be DELETEd
Date: 2002-11-18 14:19:03
Message-ID: 15832.63191.370448.410805@kelvin.csl.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Take a look in: sqlca.sqlerrd[2]

(and if you're going to post on a public list, use a real email
address)

Lee.

"\"Matthew V.\" writes:
> 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Haris Peco 2002-11-18 14:31:34 Re: DECLARE CURSOR
Previous Message Chris Bowlby 2002-11-18 14:12:12 Re: Inquiry From Form [pgsql]