Re: Receiving data in binary format how is it encoded?

Hello:

> Yeah, while waiting for the response, I added support for the int4 
> datatype. It is really encoded as a 4 bytes value.

:)

> Uhmmm, where did you take the 2000,1,1 as base from?
> If the date is before 2000, days will have a negative value, so date is 
> calculated correctly backwards?

In the little tests i do, yes.


> Thanks Carlos. do you know in what file are these values produced?

Not sure but i'm reviewing files in directory:

src\backend\utils\adt

This is what seems to be sent for numeric datatype i'm going to test it 
now :D:
pq_sendint(&buf, x.ndigits, sizeof(int16));pq_sendint(&buf, x.weight, sizeof(int16));pq_sendint(&buf, x.sign,
sizeof(int16));pq_sendint(&buf,x.dscale, sizeof(int16));for (i = 0; i < x.ndigits; i++)    pq_sendint(&buf,
x.digits[i],sizeof(NumericDigit));
 






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain