On Fri, Oct 8, 2010 at 3:08 PM, Pavel Stehule <pavel.steh...@gmail.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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
