arrays in stored procedures

Thank you for all your help before this. There was some problem with the server
and my post got sent three or four times, strange times are upon us.

Anyway I would like to use arrays in a stored procedure I'm writing and the
compiler doesn't seem to like it.

Are arrays supported in PL/Psql?

How would one find the length of an array?

What I am trying to do is run a select which will return 5 values, which are
then stuck into an array........................but I can't get it working.

If anybody has any ideas, I would be very grateful

Below is the simplest thing I can think of for an array and yet it won't work.

I've read the documentation but it doesn't say anything about arrays and stored
procedures

Thanks

Shane.

---------------------------------------------------------------

drop function collie();

CREATE FUNCTION collie() RETURNS integer AS '
DECLARE
rooskey integer[];
shane integer;
BEGIN
shane := rooskey[1] = {23};

RETURN shane;
END;


' LANGUAGE 'plpgsql';

-------------------------------------------------------------------