"Eliot, Christopher" <christopher(dot)eliot(at)nagrastar(dot)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