From: Jeff Lynn <jmlynn@rogers.com>
To: pgsql-interfaces@postgresql.org
To: andrewm@object-craft.com.au
Subject: Re: PQgetvalue failed to return column value for non-text data in binary format
Date: Tue, 22 May 2007 14:17:53 -0400
Message-ID: <465333D1.2020505@rogers.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jmlynn@rogers.com, andrewm@object-craft.com.au
Subject: Re: PQgetvalue failed to return column value for non-text data in binary format
In-Reply-To: <465333D1.2020505@rogers.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox