Re: PQgetvalue failed to return column value for non-text data in binary format

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