"Peter T. Breuer" <ptb(at)inv(dot)it(dot)uc3m(dot)es> writes:
> "Also sprach Tom Lane:"
>> 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.
No, that works for a 7.4 server too; we haven't changed the protocol
since then. (I forget though to what extent 7.4 libpq exposes the
capability.)
regards, tom lane