o Allow array declarations and other data types in PL/PgSQL DECLARE o Allow PL/PgSQL to support array element assignment
AFAIK, these two are not done, but they are redundant. Either one requires the implementation of the other.
They are done (at least the array declarations and array element assignment part):
create or replace function test() returns integer[] as '
declare
v_ret integer[] := ''{}'';
begin
v_ret[1] := 1;
v_ret[2] := 2;
return v_ret;
end;
' language plpgsql;
CREATE FUNCTION
regression=# select test();
test
-------
{1,2}
(1 row)o Add PL/PgSQL PROCEDURES that can return multiple values
Hmmm ... I know how this got on the TODO, but it's a fragment of a larger suggestion about PROCEDURES vs. FUNCTIONS. I don't think it makes much sense on its own without the other elements; maybe we should take it off until I can make a full proposal?
Is this somehow different from table functions (SRFs)?
o Add table function support to pltcl, plperl, plpython
If this was done, I would dearly love to know about it ...
Pretty much sure this has not been done. I'll be happy to work with someone if they want to pick this up, but I don't use them enough to feel comfortable doing it myself.
Joe
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
