Re: [SQL] Getting multiple rows in plpgsql function

2003-01-24 Thread Guy Fraser
NOTE: This is a feature in 7.3 it was either added or fixed, so you will not be able to do this unless you are using version 7.3. Remember to backup with pg_dumpall before you upgrade. This is a sample sent to me earlier this week, that iterates an integer array: Cut Here CREATE

Re: [SQL] Getting multiple rows in plpgsql function

2003-01-24 Thread Roberto Mello
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 t