Received: from WEBBSD1.turnaround.com.au (webbsd1.turnaround.com.au [203.39.138.49]) by hub.org (8.9.2/8.9.1) with ESMTP id AAA17616 for ; Thu, 11 Mar 1999 00:01:08 -0500 (EST) (envelope-from J_Shevland@TurnAround.com.au) Received: from tasshev (dhcp110.turnaround.com.au [192.168.1.110]) by WEBBSD1.turnaround.com.au (8.8.7/8.8.7) with SMTP id QAA11101 for ; Thu, 11 Mar 1999 16:05:05 +1100 (EST) (envelope-from J_Shevland@TurnAround.com.au) Reply-To: From: "Joe Shevland" To: Subject: Stored Procedure FAQ Date: Thu, 11 Mar 1999 15:56:34 +1100 Message-ID: <002601be6b7b$898d97a0$6e01a8c0@tasshev.turnaround.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Importance: Normal Hi (asbestos suit donned), I've attempted to swim through the mail archives on this one, and my question has been asked but I couldn't locate an answer. The doco is a bit lightweight on functions/stored procs too. So: how can I implement a stored procudure/function that returns a resultset? I saw the one using the 'setof' operator which I'd never seen before, and that was returning integer values and I don't think the guy got a response. I saw another one with no response too. Cheers and TIA, Joe. -- Joe Shevland Turnaround Solutions Pty. Ltd. mailto:J_Shevland@Turnaround.com.au http://www.TurnAround.com.au Ph: +61-03-6224-9146 Fax: +61-03-6223-2556