Postgres Pro
Downloads
Home   >   mailing lists

Cannot declare arrays? - Mailing list pgsql-sql

From Josh Berkus
Subject Cannot declare arrays?
Date
Msg-id 3AAD72B0.DC5C7900@agliodbs.com
Whole thread Raw
In response to Re: default value syntax - pg compared to?  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: help
Next
From: "Alder"
Date:
Subject: SQL Dummy Needs Help