| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | sqllist <pgsql-sql(at)postgresql(dot)org>, Jeff MacDonald <jeff(at)pgsql(dot)com> |
| Subject: | Cannot declare arrays? |
| Date: | 2001-03-13 01:06:56 |
| Message-ID: | 3AAD72B0.DC5C7900@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Spy | 2001-03-13 01:31:06 | Re: Use of the LIMIT clause ? |
| Previous Message | Carl van Tast | 2001-03-12 23:34:09 | Re: default value syntax - pg compared to? |