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/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
