Re: return value for PQbinaryTuples

On Fri, Nov 27, 2009 at 3:33 AM, bbhe <bbhe_2001(at)163(dot)com> wrote:
> hi all,
>
> I don't why PQbinaryTuples function returns 1
> even the select statement only returns two integer fields.
> Although there are some columns with type bytea in the table.

PQbinaryTuples is basically going to return whatever you passed into
resultformat when you executed the query (in the case of PQexec, it's
going to be 1 always). The specific types of fields you are querying
is immaterial. See the documentation for PQexecParams().

If you want data returned in binary you should ask for it that way
(this means not using PQexec to issue queries). If you are looking
for a broader way of dealing with binary with libpq (especially if you
are using 8.4), you will want to check out libpqtypes (which uses
binary protocol always):

/* send some data */
PGresult *res = PQexecf(conn,
"INSERT INTO t VALUES (%int4, %text)", 654321, "some text");

/* read some data out of a result */
PQgetf(res, 0, "#int4 #text", "a", &i4, "t", &text);

http://libpqtypes.esilo.com/

merlin