Re: libpq: PQexecParams, binaryFormat and float - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: libpq: PQexecParams, binaryFormat and float
Date
Msg-id 8175.1183148838@sss.pgh.pa.us
Whole thread Raw
In response to libpq: PQexecParams, binaryFormat and float  ("Sun, Way" <Way.Sun@sciatl.com>)
List pgsql-interfaces
"Sun, Way" <Way.Sun@sciatl.com> writes:
>     float    loadavg;
>     loadavg = htonl(1.23);

It seems entirely unlikely that that will produce a byte-reversed float
value; what I think will happen is that the byte-reversed value of
integer 1 will be converted into a host-format float and stored into
loadavg.

AFAIK you can't really do this in C without a union.  Take a look at 
pq_sendfloat4 and pq_getmsgfloat4 in the backend for examples.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: "Sun, Way"
Date:
Subject: libpq: PQexecParams, binaryFormat and float
Next
From: "anoopmadavoor@gmail.com"
Date:
Subject: How I can return a set of recordset from PL/Python