Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAFHYFs18155; Wed, 15 Nov 2000 12:34:15 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [206.169.43.130] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.3) with ESMTP id 1119544; Wed, 15 Nov 2000 09:32:52 -0800 Message-ID: <3A12C87A.390C6346@agliodbs.com> Date: Wed, 15 Nov 2000 09:31:38 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions X-Mailer: Mozilla 4.73 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: sqllist , phpp Subject: Re: Re: [SQL] FTI, paged, ranked searching and efficiency. References: <3A36DC72@operamail.com> <3A12C1DA.D296628C@agliodbs.com> <20001115122516.B25685@bang.dhs.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/18 X-Sequence-Number: 26 Stephen, > How come nobody's ever thought of cursors? > > DECLARE foo CURSOR FOR SELECT stuff FROM stuff WHERE foo ORDER BY > something; > > Hop forward N rows? > MOVE FORWARD $n IN foo > > Want M rows? > FETCH FORWARD $m IN foo I'm intrigued by this. How would I retrieve cursor rows into a web application? If we could output a cursor to a functon result (we can't), it would be easy, but I'm not sure otherwise. -Josh -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 436-9166 for law firms, small businesses fax 436-0137 and non-profit organizations. pager 338-4078 San Francisco