Re: Getting multiple rows in plpgsql function

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: David Durst <ddurst(at)larubber(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Getting multiple rows in plpgsql function
Date: 2003-01-24 22:36:27
Message-ID: 20030124223626.GB24536@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Durst 2003-01-24 23:41:17 Function for adding Money type
Previous Message David Durst 2003-01-24 21:19:26 Re: Scheduling Events?