Re: proposal: plpgsql, solution for derivated types of parameters

On Fri, Oct 8, 2010 at 3:08 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> I propose a following syntax:
>
> -- variable as element of some array
> DECLARE elementvar IS ELEMENT OF arrayvar;
> DECLARE elementvar IS ELEMENT OF arrayvar%type
>
> -- variable as array of some variable
> DECLARE arrayvar IS ARRAY OF varname;
> DECLARE arrayvar IS ARRAY OF varname%type
>
> This proposal doesn't introduce any new reserved keywords.

FYI, Oracle PL/SQL supports type declaration and array
variables are declare as the type.

DECLARE
TYPE array_type_name IS {VARRAY | VARYING ARRAY} (size_limit)
OF element_type [NOT NULL];
a1 array_type_name;

"IS ARRAY OF" syntax is similar enough to PL/SQL, but is not compatible.

I'm not sure whether PL/SQL has "IS ELEMENT OF" variants.

--
Itagaki Takahiro