On Fri, Nov 27, 2009 at 3:33 AM, bbhe <bbhe_2001@xxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
