On 5/26/07, Peter T. Breuer <[EMAIL PROTECTED]> wrote:
"Also sprach Tom Lane:"
> "Peter T. Breuer" <[EMAIL PROTECTED]> writes:
> > But can I prepare a DECLARE x BINARY CURSOR FOR SELECT ... statement?
> > The manual seems to say no.
>
> No, you just prepare the SELECT. At the protocol level, DECLARE CURSOR
> is a tad useless. You can still fetch the data in binary if you want...
How? It's a 7.4 server (or may be, more generally) and declare binary
cursor is the only way I know to get binary data off it. AFAIR the only
other way works only for an 8.* server and consists of sending the query
with an annotation that a binary reply is expected.
You want to be calling PQexecPrepared and flip the resultFormat.
http://www.postgresql.org/docs/7.4/interactive/libpq-exec.html#LIBPQ-EXEC-MAIN
IMO, it's usually not worth bothering with binary unless you are
dealing with bytea objects.
merlin
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
