From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Joe Conway <mail(at)joeconway(dot)com> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: TODO items |
Date: | 2003-08-08 16:35:13 |
Message-ID: | 200308081635.h78GZDd27161@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Mendola Gaetano | 2003-08-08 16:35:32 | Re: consistency check on SPI tuple count failed |
Previous Message | Bruce Momjian | 2003-08-08 16:33:52 | Re: TODO items |