I'll try with what says in the FAQ, but should someone know of a way to declare a variable that allows appending please tell me http://wiki.postgresql.org/wiki/Return_more_than_one_row_of_data_from_PL/pgSQL_functions ---------------------------------------- > > > Hi there, > I'm making a really weird stored procedure which makes use of about 5 tables... > and I need to create my own result set based on the computed result of various > FOR loops. > > Does anyone knows how can I do that using PL/pgSQL? > > I "think" I need to declare a couple of variables that accept APPENDING but I > don't know if that's possible. > > Lets say for example: > CREATE OR REPLACE FUNCTION weirdFunction() RETURNS AS $$ > DECLARE > column1 ; > column2 ; > BEGIN > --first row > column1.append('something'); > column2.append('something'); > > --second row > column1.append('again'); > column2.append('again'); > > END; > $$ LANGUAGE plpgsql; > > So the result of that should be > something something > again again > > Is it possible to do something like that? > > > Tanks in advance _________________________________________________________________ Plug&Play te trae en exclusiva los mejores conciertos de la red http://club.prodigymsn.com/
