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

Carlos Guzman Alvarez wrote:

> Hello:
> 

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.

Good. I think I found where you get 200,1,1 from:
In datetime.c in the AST dir, there is a line which says:
Assert(POSTGRES_EPOCH_JDATE == date2j(2000, 1, 1));


> 
> 
>> 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));
> 
> 

Thanks. I will have a look in the types in the AST dir.


-- 
Regards,

Francisco Figueiredo Jr.

------
"My grandfather once told me that there are two
kinds of people: those
who work and those who take the credit. He told me
to try to be in the
first group; there was less competition there."
- Indira Gandhi