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.
pgsql-interfaces by date
|Next:||From: Jeff Lynn||Date: 2007-05-22 18:23:55|
|Subject: Re: PQgetvalue failed to return column value for non-text data in
|Previous:||From: Jeroen T. Vermeulen||Date: 2007-05-22 06:10:25|
|Subject: Re: PQgetvalue failed to return column value for
non-text data in binary format|