DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=PWnZer6EwLiVm/5hvz5a82lECjlYMpGLDMoQb43k5A213aEbjtBOWmVYvCAGXih+L0zuHKX76DLJLImFZyoVHEKCCT0xcaPGriMR5qJXsW1WFBNFb4/b/ENwa58412pFFBCTSBUUM3kUusCq52Mbf6OoQJm97bycpQ3Fb9Y9Zmw=
Message-ID: <758d5e7f0711011319t5e752dsad6481d1427a46ff@mail.gmail.com>
Date: Thu, 1 Nov 2007 21:19:44 +0100
From: "Dawid Kuroczko" <qnex42@gmail.com>
To: "Postgres General" <pgsql-general@postgresql.org>
Subject: Scrolling cursors in PL/PgSQL
Cc: pgsql-sql <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello.

Is there a way to scroll a cursor from within PL/PgSQL?

I tried EXECUTE, but:

ERROR:  cannot manipulate cursors directly in PL/pgSQL
HINT:  Use PL/pgSQL's cursor features instead.

The idea would be that PL/pgsql function would look
through (all) query results, then rewind the cursor and
finally return it.

My fellow developers have created a function which run
the (complex) query twice (first a count(*) on the result
set, then return the row count and cursor to the results.
Then they created a version which uses temporary
table as a placeholder for the query results, and results
count and a pointer to select * from tmp_table.

Now I imagined a function which would open the cursor,
MOVE FORWARD ALL, then MOVE ABSOLUTE 0;
and return count and a cursor, yet it seems it won't work.

Any other idea how to efficiently solve such a problem?

   Regards,
     Dawid