Re: Populating a sparse array piecemeal in plpgsql (REDUX)

["Webb Sprague" <webb.sprague@xxxxxxxxx>]

I am trying to return a 2-d array with filled in values, but I can't
find a way to initialize the array programmatically (ie, in a
function, with the array size being determined by parameter values.

here is one approach

> Well, the point is that you need to initialize the array as a whole to
> have the dimensions you want; PG won't guess about this.  For instance
> you could do something like
>
>        declare a integer[];
>        begin
>          a := '{{null,null,null},{null,null,null},{null,null,null}}';

 I would  like the following to get  a 3 x 3 array:

declare a integer[][]
    begin
    a := array_init(3, 3, 0)  -- this function doesn't exist, ??

Any ideas?  I guess I can do a series of appends or make some text
thing, but that seems awkward...

Tx