- pgaql long value corrupted using htons
Neeraj Rai <[email protected]> Wed, 22 May 2013 16:52:13 -0700 (PDT)
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
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