Search Postgresql Archives

Re: int values from PQExecParams in binary result mode

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Oct 03, 2005 at 12:37:30PM -0700, Ben wrote:
> I'm making a query to return an int and a bytea as two columns in my 
> query, so I set up my PQExecParams call like so:
> 
> res = PQexecParams(conn,q,0,0,0,0,0,1)
> 
> I can view the binary data just fine, but not the int. How do I do that?

The pointer that PQgetvalue() returns should point to the integer
value in network byte order.  Unless somebody suggests a better
way, you could cast PQgetvalue()'s return value to int * and
dereference it, or otherwise copy the data into an integer variable.
Use ntohl() to convert the value from network byte order to host
byte order (ntohl() and htonl() are null operations on big-endian
architectures, but it's a good idea to use them in any case for
portability and so you don't have to worry about such hardware
details).

The following example works for me (error and NULL checking omitted):

res = PQexecParams(conn, "SELECT 123456::integer", 0, NULL, NULL, NULL, NULL, 1);
ival = ntohl(*(int *)PQgetvalue(res, 0, 0));

-- 
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux