Re: Question about how to handle numeric (decimal) data types while using libpq

Hello,

I am trying to use libpq for interfacing with PostgreSQL from a C/C++ based application.

I have tried to use binary format of data for both sending and receiving data to and from server (resultFormat = 1).

As I understand most binary types, int, float etc… are encoded in bing-endian byte order and they can be converted to appropriate host specific memory representations.

However NUMERIC datatype is a more complex structure with multiple ints and pointers.

I would like to know if there are published library functions that convert (to and from) NUMERIC field to say, long double datatype


Any pointers in this regard is appreciated.