Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 41024476311 for ; Fri, 24 Jan 2003 17:57:52 -0500 (EST) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56]) by postgresql.org (Postfix) with ESMTP id 5BEC2477196 for ; Fri, 24 Jan 2003 17:30:54 -0500 (EST) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 18cCR1-0006S7-00; Fri, 24 Jan 2003 15:36:27 -0700 Date: Fri, 24 Jan 2003 15:36:27 -0700 From: Roberto Mello To: David Durst Cc: pgsql-sql@postgresql.org Subject: Re: Getting multiple rows in plpgsql function Message-ID: <20030124223626.GB24536@cc.usu.edu> References: <42509.216.86.192.34.1043437147.squirrel@www.la-rubber.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <42509.216.86.192.34.1043437147.squirrel@www.la-rubber.com> User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/405 X-Sequence-Number: 11270 On Fri, Jan 24, 2003 at 11:39:07AM -0800, David Durst wrote: > I am wondering how you would handle a select that returns multiple rows > in a plpgsql function? > > In other words lets say I wanted to iterate through the results in > the function. There are examples in the PL/pgSQL documentation that show you how to do it. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + And God said: E = ½mv² - Ze²/r, and there was light.