Re: [GENERAL] appending items to record variable

2010-05-14 Thread Merlin Moncure
On Fri, May 14, 2010 at 9:12 AM, x y wrote: > Hi all > > In plpgsql, is there a way to append rows to a record variable? > > Each time a query like > SELECT mycolumn INTO myrecordvariable FROM ... > is executed, myrecordvariable seems to be reseted and previous entries are > lost. > > What I want

[GENERAL] appending items to record variable

2010-05-14 Thread x y
Hi all In plpgsql, is there a way to append rows to a record variable? Each time a query like SELECT mycolumn INTO myrecordvariable FROM ... is executed, myrecordvariable seems to be reseted and previous entries are lost. What I want to do is collect values throughout several conditionals and th