Re: binary representation of date and numeric - Mailing list pgsql-general

From Richard Huxton
Subject Re: binary representation of date and numeric
Date
Msg-id 4631A8E6.7040409@archonet.com
Whole thread Raw
In response to binary representation of date and numeric  (Felix Kater <fkater@googlemail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: PostgreSQL upgrade server A -> server B
Next
From: "A. Kretschmer"
Date:
Subject: Re: Business days