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 that

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