plpgsql and setting array values.

Hi all

I'm writing a rrdtool replacement in pgsql and have a little problem with
plpgsql and arrays.

The problem is best shown in the following example :

--------------------------
CREATE OR REPLACE FUNCTION test1(integer[]) RETURNS float[] AS '
DECLARE
    pa_dsid ALIAS FOR $1;
    l_rv float[];
BEGIN
    FOR aoffset IN 2 .. pa_dsid[1]+1 LOOP
        -- XXX: The following is not possible..
        l_rv[aoffset]:=pa_dsid[aoffset]*4; -- Return dummyvalue (multiply by 4)
    END LOOP;
    RETURN l_rv;
END;
' language 'plpgsql';
--------------------------

The problem is that i cannot assign values to explicit array values like
myarray[2]:=123;
The only way is to say myarray:=' {12,123}'; and that is not very flexible
because I will have to build up textstrings in my stored procedure.

Any comments on this ? Have I missed some documentation or similar ?

Best regards,
Nicolai Petri
catpipe Systems ApS