Re: How to create my own result set?

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/