Re: TODO items

Josh Berkus wrote:
>>        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