"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. Peter ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend