Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2B2352E00E7 for ; Thu, 13 Mar 2008 19:54:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08017-08 for ; Thu, 13 Mar 2008 19:54:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54303.mail.re2.yahoo.com (web54303.mail.re2.yahoo.com [206.190.49.113]) by postgresql.org (Postfix) with SMTP id 7CBF52E00B1 for ; Thu, 13 Mar 2008 19:54:35 -0300 (ADT) Received: (qmail 21279 invoked by uid 60001); 13 Mar 2008 22:54:34 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=ts97ypRCJxr55vrWiyvix2jZcKhB9jfFXAgNubLxmxiKYFEl+biwwJCv50/essWOVcnPStdkg/oT8qra9VYWePSqksTkS5pvPYP/zBDS214Y+lZ7xzoNbDo3LiNGVqxBcaMq7uSE/p3tMulMJDe4t8rVcYkQtUHhG0iALPTnpl4=; X-YMail-OSG: 66JC6SQVM1lmaTUzHib_BgiFL.5rkMDhZiJ7XsGQgnL7wUCDUPoXcmloupQmcnd1IGnlZcN8mIKBwhBsKBR9cF_H5LMWxtxkiC8YzqZ2N5hnymbK5A-- Received: from [69.229.126.238] by web54303.mail.re2.yahoo.com via HTTP; Thu, 13 Mar 2008 15:54:33 PDT Date: Thu, 13 Mar 2008 15:54:33 -0700 (PDT) From: chester c young Subject: cursors and sessions To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <105895.21197.qm@web54303.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/78 X-Sequence-Number: 30406 is there any way to share a cursor between sessions? I have a costly query whose records need to be visited by in order by n number of concurrent sessions, and am unable to find the best way of doing this. I'd almost like to write a daemon that hands out the next record, but that's a royal pain to set up and maintain. ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping