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

From: Sudheer H R <sudheer(dot)hr(at)tekenlight(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Question about how to handle numeric (decimal) data types while using libpq
Date: 2021-07-06 11:04:43
Message-ID: 63A4A360-8A41-476B-A5B6-D00088D6F590@tekenlight.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Regards,
Sudheer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Igrishin 2021-07-06 11:48:45 Re: Question about how to handle numeric (decimal) data types while using libpq
Previous Message David Rowley 2021-07-06 09:52:13 Re: When to REINDEX a serial key?