Re: Populating a sparse array piecemeal in plpgsql

"Eliot, Christopher" <christopher.eliot@nagrastar.com> writes:
> CREATE FUNCTION func1()
> RETURNS VOID AS $$
> DECLARE
>     a INTEGER[2][2][2][200];
> BEGIN
>     a[1][2][1][33] = 0;
>     a[2][1][1][33] = 0;
> END;
> $$ LANGUAGE PLPGSQL;

> When I run this function, I get:
> ERROR:  array subscript out of range.

Yeah.  I'm afraid that declaration is basically just noise: it doesn't
do anything for you that "DECLARE a integer[];" wouldn't do.  If you
want the array actually filled out to the indicated dimensions then
you have to do that by hand.

            regards, tom lane