How to create my own result set?

["Ismael ...." <ismaelpsp@xxxxxxxxxxx>]

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/