Обсуждение: How to create my own result set?

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
_________________________________________________________________
Tenemos lo que búscas…JUEGOS.
http://club.prodigymsn.com/

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/