Why is 0 returned in PQcmdTuples?

Started by Boszormenyi Zoltanabout 16 years ago1 messages
#1Boszormenyi Zoltan
zb@cybertec.at

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/