testlibqp-dt.c is attached
>________________________________
> From: Neeraj Rai <rneeraj(at)yahoo(dot)com>
>To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
>Sent: Wednesday, May 22, 2013 7:52 PM
>Subject: [INTERFACES]- pgaql long value corrupted using htons
>
>
>
>Hi,
>
>
>1. I am having trouble writing long values via c interface .testlibqp-dt.c is attached.
>. 2 is being inserted as 8589934592.
>
>
>
>
>qsf=> select * from t1;
> curdate | strf | intf | tm_new | txnid
>------------+--------+--------------------+------------------------+-------
>1999-01-10 | hello2 |8589934592 | 1999-01-08 04:05:06-05 | 3
>
>
>I tried htobe64 but that didn't help either.
>Any advise would be appreciated.
>
>
>
>2. I have switched to using string for data and timestamp and it seems to work.
>
>
>I found functions like TimestampTzGetDatum,time_t_to_timestamptz in the code
>But it seems they are not exposed to interface.
>I have the date time in unix format (via time and gettimeofday). I would prefer to pass those values
>in binary, rather than string format. Is there any option to do this ? Or is it easily addable?
>
>
>thanks
>Neeraj
>
>
>
>