Joe Conway wrote:
> 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)
>
OK, marked as done.
> >> 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)?
Yes, I am unsure what it is. Removed pending later proposal.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073