- pgaql long value corrupted using htons
| От | Neeraj Rai |
|---|---|
| Тема | - pgaql long value corrupted using htons |
| Дата | |
| Msg-id | 1369266733.72536.YahooMailNeo@web164902.mail.bf1.yahoo.com обсуждение исходный текст |
| Ответ на | Re: - pgaql binary data date time fornats (Neeraj Rai <rneeraj@yahoo.com>) |
| Ответы |
Re: - pgaql long value corrupted using htons
|
| Список | pgsql-interfaces |
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
В списке pgsql-interfaces по дате отправления: