Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9580D9FA344 for ; Thu, 1 Nov 2007 18:23:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 77977-03-5 for ; Thu, 1 Nov 2007 18:22:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail26.svc.cra.dublin.eircom.net (mail26.svc.cra.dublin.eircom.net [159.134.118.55]) by postgresql.org (Postfix) with SMTP id CF8E99FC957 for ; Thu, 1 Nov 2007 18:02:45 -0300 (ADT) Received: (qmail 35728 messnum 5060107 invoked from network[86.42.35.78/86-42-35-78.b-ras1.mvw.galway.eircom.net]); 1 Nov 2007 21:02:43 -0000 Received: from 86-42-35-78.b-ras1.mvw.galway.eircom.net (HELO ?127.0.0.1?) (86.42.35.78) by mail26.svc.cra.dublin.eircom.net (qp 35728) with SMTP; 1 Nov 2007 21:02:43 -0000 Message-ID: <472A3EF2.4080202@iol.ie> Date: Thu, 01 Nov 2007 21:02:42 +0000 From: Raymond O'Donnell Reply-To: Raymond O'Donnell User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 CC: Postgres General , pgsql-sql Subject: Re: Scrolling cursors in PL/PgSQL References: <758d5e7f0711011319t5e752dsad6481d1427a46ff@mail.gmail.com> In-Reply-To: <758d5e7f0711011319t5e752dsad6481d1427a46ff@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 071101-0, 01/11/2007), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.721 tagged_above=0 required=5 tests=AWL=-0.572, BAYES_50=0.001, MISSING_HEADERS=1.292 X-Spam-Level: X-Archive-Number: 200711/40 X-Sequence-Number: 123036 On 01/11/2007 20:19, Dawid Kuroczko wrote: > Any other idea how to efficiently solve such a problem? How about creating a temporary table within your function and using that instead? Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------