[SQL] Cannot declare arrays?

[Josh Berkus]

Folks,

        I'm trying to delcare an array (of type Numeric) within a PL/pgSQL
function.  No matter what syntax I try, however, I get a compile error. 
I've tried:

DECLARE
level_array NUMERIC(8,2)[];
level_array NUMERIC[](8,2);
level_array NUMERIC[];
level_array[] NUMERIC(8,2);

and even:
level_array MONEY[100];

        Please help!

-Josh Berkus



-- 
______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology      [EMAIL PROTECTED]
    and data management solutions       (415) 565-7293
   for law firms, small businesses       fax  621-2533
    and non-profit organizations.       San Francisco

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster