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/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
