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