From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Hinkle <drachs@gmail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: libpq, PQExecParams and the inserting of binary data
Date: Fri, 03 Jun 2005 15:11:22 -0400
Message-ID: <12005.1117825882@sss.pgh.pa.us> (raw)
In-Reply-To: <ae830e6c0506031104140a2b35@mail.gmail.com>
References: <ae830e6c05060309182201f85b@mail.gmail.com>
<6424.1117820918@sss.pgh.pa.us>
<ae830e6c0506031104140a2b35@mail.gmail.com>
David Hinkle <drachs@gmail.com> writes:
> ... That example doesn't show you how to use
> any binary parameters... All the parameters are text, it only shows
> you how get binary results. I think it's a huge oversight myself.
Duh, you are right. Will fix that.
> I could probably figure out how to use the parameters as binary, but I
> have no idea what to do with the OID field.
If you didn't need it for the text version, you won't need it for the
binary version. The type OID is only needed if the query is such that
the backend can't determine the type of the parameter symbol from
context. Whether you send the parameter value as text or binary has
nada to do with that.
regards, tom lane
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: tgl@sss.pgh.pa.us, drachs@gmail.com
Subject: Re: libpq, PQExecParams and the inserting of binary data
In-Reply-To: <12005.1117825882@sss.pgh.pa.us>
* 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