Re: number of affected rows in pgtcl - Mailing list pgsql-general

From Tom Lane
Subject Re: number of affected rows in pgtcl
Date
Msg-id 22536.1035554116@sss.pgh.pa.us
Whole thread Raw
In response to Re: number of affected rows in pgtcl  (Christian Traber <christian@traber-net.de>)
List pgsql-general
Christian Traber <christian@traber-net.de> writes:
>> Doesn't pg_result provide a way to get that?

> No, pg_result -numTuples only returns the number of found rows of a
> select statement.

Um, you're right; there's no interface to PGcmdTuples in pg_result.
Perhaps there should be.  But the short-term answer is to use pg_execute
instead of pg_exec.  See
http://developer.postgresql.org/docs/postgres/pgtcl-pgexecute.html
(this unaccountably escaped being documented before 7.3, but it's
been there since 7.1 or so).

            regards, tom lane

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: lpad question
Next
From: Andrew Sullivan
Date:
Subject: Re: [ADMIN] postgresql 7.2.1 and smp ?