Why is 0 returned in PQcmdTuples?

From: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Cc: Hans-Juergen Schoenig <hs(at)cybertec(dot)at>
Subject: Why is 0 returned in PQcmdTuples?
Date: 2009-11-25 12:11:38
Message-ID: 4B0D1EFA.4060406@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I know it's documented that CREATE TABLE ... AS SELECT ...
and SELECT ... INTO TEMP ... returns "0" as number of
affected tuples via PQcmdTuples().

Why?
How much work would it be to pass this info up?

The question arose because in ECPG, such statements
like the above returns 0 in sqlca.sqlerrd[2], but Informix
returns the number of tuples copied.

Best regards,
Zoltán Böszörményi

--
Bible has answers for everything. Proof:
"But let your communication be, Yea, yea; Nay, nay: for whatsoever is more
than these cometh of evil." (Matthew 5:37) - basics of digital technology.
"May your kingdom come" - superficial description of plate tectonics

----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2009-11-25 12:21:37 Re: Hot Standby remaining issues
Previous Message Heikki Linnakangas 2009-11-25 11:00:30 Hot Standby remaining issues