- pgaql long value corrupted using htons

Поиск

Список

Период

Сортировка

От	Neeraj Rai
Тема	- pgaql long value corrupted using htons
Дата	23 мая 2013 г. 14:53:56
Msg-id	1369310024.8114.YahooMailNeo@web164904.mail.bf1.yahoo.com обсуждение исходный текст
Список	pgsql-general

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 am 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-general по дате отправления:

От: Wojciech Skaba
Дата: 23 мая 2013 г., 12:40:52
Сообщение: update ARRAY of COMPOSITE TYPE of text

От: Chris Ernst
Дата: 23 мая 2013 г., 15:05:01
Сообщение: Re: VACUUM FULL freezes