[GENERAL] binary representation of date and numeric

2007-04-27 Thread Felix Kater
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

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [GENERAL] binary representation of date and numeric

2007-04-27 Thread Richard Huxton

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

---(end of broadcast)---
TIP 6: explain analyze is your friend