Re: plpgsql array initialization, what's the story?

On Thu, Mar 31, 2005 at 07:13:30PM +0000, Karl O. Pinc wrote:
> Postgresql 8.0.1
>
> If I write the plpgsql:
>
> declare
> y int[];
> begin
> y[1] := 1;
> y[2] := 2;
> y[3] := 3;
> ...
>
> All y[] array elements are NULL, as is array_dims(y).

I think this has been fixed for 8.0.2:

http://archives.postgresql.org/pgsql-committers/2005-02/msg00012.php

Here's a test in 8.0.2beta1:

CREATE FUNCTION foo() RETURNS integer[] AS $$
DECLARE
    y  integer[];
BEGIN
    y[1] := 1;
    y[2] := 2;
    y[3] := 3;

    RETURN y;
END;
$$ LANGUAGE plpgsql;

SELECT foo();
   foo
---------
 {1,2,3}
(1 row)

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/