DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=rogers.com;
	h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding;
	b=cYftMXrV64fXwDpbJmhpYIrNiVoLmXAmWqcWM10+JpdJTnAK9TghoNyonEoTi/ZNBVpxNDSHIbHYGSeH53Mu9U5scOI1Vg5owhvJJ/gmDqiHwPhcTc7/lhKAEwmbtTM8mMDMonRxgKNCJfrP/osYEK/IzV8ZD9gZ79UXG/4Dmuw=
	;
Message-ID: <46546220.4060209@rogers.com>
Date: Wed, 23 May 2007 11:47:44 -0400
From: Jeff Lynn <jmlynn@rogers.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Re: How do you convert PostgreSQL internal binary field to C
 datatypes
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I give up!  What ever data returned from the binary output of 
PGgetvalue() is, I don't know how to convert it into StringInfo, which 
is being used by a few routines that "seems" to convert internal binary 
format into float8.  By casting the returned data into StringInfo, 
crashes the function.

If PostgreSQL  support only a half baked C API, may as well don't bother.

So I gave up.   I will not use PostgreSQL until there is a simple way to 
extract data directly into C or C++ data type.  Is one expect to fetch 
data in text, then use text to int, text to double, text to date 
function before you can make any business logic works?

Thanks all of you trying to help.  Appreciated!

Jeff