Cannot declare arrays?
| От | Josh Berkus |
|---|---|
| Тема | Cannot declare arrays? |
| Дата | |
| Msg-id | 3AAD72B0.DC5C7900@agliodbs.com обсуждение исходный текст |
| Ответ на | Re: default value syntax - pg compared to? ("Josh Berkus" <josh@agliodbs.com>) |
| Список | 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 informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
В списке pgsql-sql по дате отправления: