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=sQYN0CqXgJ/JuPHWMluxuUzJOV9hSgouXaZumRtvKeZ9rcUiVXGhuHXZxXiW8j8JsLnAinXAlvG9zkCdcGL+zu6wGtm4dRs2pKurl1Y/NiHWXbm42skh/RIXJAeoEsv4jibd9UhaW2uR3YACCVNtNUJAiLimS8uZrDhDmq6N43c=
	;
Message-ID: <465333D1.2020505@rogers.com>
Date: Tue, 22 May 2007 14:17:53 -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,  andrewm@object-craft.com.au
Subject: Re: PQgetvalue failed to return column value for non-text data in
	binary format
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Thank you for your comment about text and binary format.  To use text, I 
thought one will have to construct the insert sql statement on the fly, 
which will incurs server parsing, syntax checking followed by 
execution.  With binary format, I can simply prepare a statement and 
then update each binded parameter prior to execute the prepared 
statement over each records.

Is there a way for me to prepare the insert statment and pass in text 
instead of, say, double precision?  I experimented with that the the 
server reject the insert statement with "mismatched datatype" error.

Jeff