Received: from cr322781-a.ym1.on.wave.home.com (cr322781-a.ym1.on.wave.home.com [24.112.37.89]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAFHSrs17948; Wed, 15 Nov 2000 12:28:53 -0500 (EST) (envelope-from svanegmond@bang.dhs.org) Received: from svanegmond by cr322781-a.ym1.on.wave.home.com with local (Exim 3.16 #1 (Debian)) id 13w6Ma-0006gt-00; Wed, 15 Nov 2000 12:28:48 -0500 Date: Wed, 15 Nov 2000 12:28:48 -0500 To: Josh Berkus Cc: sqllist , phpp Subject: Re: Re: [SQL] FTI, paged, ranked searching and efficiency. Message-ID: <20001115122848.C25685@bang.dhs.org> Reply-To: svanegmond@home.com References: <3A36DC72@operamail.com> <3A12C1DA.D296628C@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3A12C1DA.D296628C@agliodbs.com>; from josh@agliodbs.com on Wed, Nov 15, 2000 at 09:03:22AM -0800 From: Stephen van Egmond X-Archive-Number: 200011/17 X-Sequence-Number: 25 My example wasn't complete. You need to wrap the cursor calls in BEGIN and END. Read the DECLARE docs for the minutiae. /Steve