X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id EBFA2DBF66
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 22 Nov 2005 23:39:04 -0400 (AST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 58043-09
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 23 Nov 2005 03:39:06 +0000 (GMT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from nz.telogis.com (unknown [203.98.10.169])
	by svr1.postgresql.org (Postfix) with ESMTP id 99B69DB8A5
	for <pgsql-performance@postgresql.org>;
	Tue, 22 Nov 2005 23:39:00 -0400 (AST)
Received: from [192.168.3.1] ([192.168.3.1])
	by nz.telogis.com with esmtp; Wed, 23 Nov 2005 16:39:04 +1300
	id 007327AB.4383E458.000017DD
Message-ID: <4383E459.2070906@telogis.com>
Date: Wed, 23 Nov 2005 16:39:05 +1300
From: Ralph Mason <ralph.mason@telogis.com>
User-Agent: Thunderbird 1.4 (Windows/20050908)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Binary Refcursor possible?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0 required=5 tests=[none]
X-Spam-Score: 0
X-Spam-Level: 
X-Archive-Number: 200511/462
X-Sequence-Number: 15719

Hi,

I am trying to get better performance reading data from postgres, so I 
would like to return the data as binary rather than text as parsing it 
is taking a considerable amount of processor.

However I can't figure out how to do that! I have functions like.

function my_func(ret refcursor) returns refcursor AS

$$

BEGIN
OPEN $1 for select * from table;
return $1
END;

$$ language 'plpgsql'

There are queried using

SELECT my_func( 'ret'::refcursor); FETCH ALL FROM ret;

Is there any way I can say make ret a binary cursor?

Thanks
Ralph