Re: Question about how to handle numeric (decimal) data types while using libpq - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Question about how to handle numeric (decimal) data types while using libpq
Date
Msg-id e3edc85a-3b03-8564-439b-01509b47d637@enterprisedb.com
Whole thread Raw
In response to Question about how to handle numeric (decimal) data types while using libpq  (Sudheer H R <sudheer.hr@tekenlight.com>)
List pgsql-general
On 06.07.21 13:04, Sudheer H R wrote:
> 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
appropriatehost 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
doubledatatype
 

There is a third-party library called libpqtypes out there that adds 
support for handling specific types on the libpq side.  But I'm not sure 
how up to date it is.



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: When to REINDEX a serial key?
Next
From: Rob Sargent
Date:
Subject: Re: When to REINDEX a serial key?