DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject
	:content-type:content-transfer-encoding;
	b=xruDJCyDDGu+rCU1MOoW/VwaulQDZxPIcWu/dYx9enR/99Bf44irlus3YqJWL3F0nD
	yy22YX0TS0ART/1fTUTrxZvnJqGBi+R0iapjVqiv9daB6M671WKZH1/q3/dnz/S5B3hW
	AkrUweQDQd++mVqq3CLjKpBVx/FLSDqWzcm8A=
Message-ID: <4C2174CD.7010304@gmail.com>
Date: Wed, 23 Jun 2010 11:43:25 +0900
From: Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; ja;
	rv:1.9.1.10) Gecko/20100512 Thunderbird/3.0.5
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: ECPG/SQLDA question - parsing an "interval" binary form
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit

Hi all,

I have a question on parsing an "interval" binary form.

I'm working on ECPG/SQLDA things, and being stuck in front of
retreiving "interval" values.

Through SQLDA, "interval" values are returned in the 12 bytes binary form,
so I have to parse it to use the interval values in the host program.

-----------------------------------------------
interval form: '10 years 5 hours 10 minutes 1 second'::interval
binary form: 40 bc b4 54 04 00 00 00 78 00 00 00
-----------------------------------------------

However, I don't have an appropriate way to parse and convert it
into host variable structures, like "time_t", "struct tm" or else.

Do you have any good way or good routine to parse the PostgreSQL
"interval" binary form for the host (C language) program?

Regards,

-- 
NAGAYASU Satoshi <satoshi.nagayasu@gmail.com>