Postgres Pro
Downloads
Home   >   mailing lists

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

From Dmitry Igrishin
Subject Re: Question about how to handle numeric (decimal) data types while using libpq
Date
Msg-id CAAfz9KNXJM=hr1nmauQ9=dt281qYuo4L5-JCOL3H8ch6930yMw@mail.gmail.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>)
Responses Re: Question about how to handle numeric (decimal) data types while using libpq  (Sudheer H R <sudheer.hr@tekenlight.com>)
List pgsql-general
Tree view


On Tue, Jul 6, 2021, 14:04 Sudheer H R <sudheer.hr@tekenlight.com> wrote:
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.
Why not just use text format for NUMERIC?

pgsql-general by date:

Previous
From: Sudheer H R
Date:
Subject: Question about how to handle numeric (decimal) data types while using libpq
Next
From: Sudheer H R
Date:
Subject: Re: Question about how to handle numeric (decimal) data types while using libpq