Received: from maggie.eskom.co.za (mail-spool2-1.eskom.co.za [147.110.52.115]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA68G0s50463 for ; Mon, 6 Nov 2000 03:16:02 -0500 (EST) (envelope-from Marc.Rohloff@eskom.co.za) Received: from eskom.co.za (gw.eskom.co.za [147.110.52.108]) by maggie.eskom.co.za (8.11.1/8.11.1/check_local4.1) with SMTP id eA68FLj28620 for ; Mon, 6 Nov 2000 10:15:21 +0200 X-Spam-Filter: check_local by digitalanswers.org Received: from ROUTING-Message_Server by eskom.co.za with Novell_GroupWise; Mon, 06 Nov 2000 10:15:21 +0200 Message-Id: X-Mailer: Novell GroupWise Internet Agent 5.5.3.1 Date: Mon, 06 Nov 2000 10:15:07 +0200 From: "Marc Rohloff" To: Subject: Returning Recordsets from Stored-procs Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id eA68GNs50504 X-Archive-Number: 200011/39 X-Sequence-Number: 70 Is there anyway to return a recordset from a Stored Procedure in Postgres so that it can be used as a type of view or select? I know that you can do this in Interbase or MS-SQL. I have seen that you can return a complete record but that's not really the same thing. Marc Rohloff