Thread: binary representation of date and numeric

binary representation of date and numeric

From
Felix Kater
Date:
Hi,

what is the binary representation of 'date' and 'numeric' data?

I am using PQexecParam (C binding libpq-8.0.12) with binary export
switched on. From the three examples in C code the types 'int4', 'bytea'
and strings are covered, however nothing about 'date', 'numeric'.

If there is no documentation and I need to examine the sources, could
anyone point me to the needed files or sections?

Thank You

Felix

Re: binary representation of date and numeric

From
Richard Huxton
Date:
Felix Kater wrote:
> Hi,
>
> what is the binary representation of 'date' and 'numeric' data?
>
> I am using PQexecParam (C binding libpq-8.0.12) with binary export
> switched on. From the three examples in C code the types 'int4', 'bytea'
> and strings are covered, however nothing about 'date', 'numeric'.
>
> If there is no documentation and I need to examine the sources, could
> anyone point me to the needed files or sections?

You'll want to look in src/backend/utils/adt. Note that timestamps can
be compiled as floating-pt representations or int64, so you probably
want to check whether that has any impact on dates.

--
   Richard Huxton
   Archonet Ltd