Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id 2D171475AEC for ; Fri, 22 Feb 2002 16:11:12 -0500 (EST) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g1ML0nb06803 for pgsql-sql@postgresql.org; Fri, 22 Feb 2002 15:00:49 -0600 (CST) (envelope-from news) From: Mark Nielsen X-Newsgroups: comp.databases.postgresql.sql Subject: How do I return more than one value in a postgresql pl/pgsql procedure? Date: Fri, 22 Feb 2002 12:56:53 -0500 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 15 Message-ID: <3C768665.30500@kepnet.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: news@hub.org User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.5) Gecko/20011012 X-Accept-Language: en-us To: pgsql-sql@postgresql.org X-Archive-Number: 200202/328 X-Sequence-Number: 6750 Hello! I am have been trying to figure out how I can get a pl/pgsql procedure to return more than one variable or perhaps a row. A procedure you create can accept more than one variable, I don't see why it shoudn't be able to return more than one variable in some fashion.I read rumors that pl/pgsql can return rows (which would contain one or more variables per row), but I didn't find hard examples of how to do it. What table lists the stored procedures you created with pl/pgsql or pl/perl? I was trying to find it with /dS in psql, but I didn't see anything obvious. Thanks! Mark