"Donald Fraser" <demolish(at)cwgsy(dot)net> writes:
> CREATE OR REPLACE FUNCTION test_arrays() RETURNS int4[] AS '
> DECLARE
> test int4[];
> BEGIN
> test[1] := 1;
> RETURN test;
> END ' LANGUAGE 'plpgsql';
> If I try to execute this function I get:
> WARNING: plpgsql: ERROR during compile of test_arrays near line 5
> ERROR: syntax error at or near "["
Existing releases of plpgsql don't support assignment to array elements.
I believe Joe Conway has fixed this for 7.4, though.
regards, tom lane