Stephane Raimbault wrote:
>
> It seems some changes occured in network protocol between 7.3 and 7.4.
Big understatement! It was completely redesigned.
> In my simple libray above libpq, I used this call to extract float8 with
> a binary cursor (on x86) :
> ...
Pre-7.4, binary data came back in the server's byte order. Starting 7.4,
data always comes back in "network data order", which is big-endian,
regardless of server or client architecture. This is a big improvement, so
you can now portably deal with binary data. The proper way to do so in the
client is to use the ntohs() and ntohl() functions to turn network data
order into native order.