Thread: arrays of numeric?

I'm running 6.5.1 on FreeBSD, and I'm trying to create a table with an
array of numerics. I do this:

test=> create table test (num numeric(10,2)[]);

and I get this:

ERROR:  Unable to locate type name '_numeric' in catalog

I've hunted around in the documentation, but I've found nothing saying this
is _not_ possible.  Am I missing something here?

On 1999-11-04, Vince Gonzalez mentioned:

> I'm running 6.5.1 on FreeBSD, and I'm trying to create a table with an
> array of numerics. I do this:
> 
> test=> create table test (num numeric(10,2)[]);
> 
> and I get this:
> 
> ERROR:  Unable to locate type name '_numeric' in catalog
> 
> I've hunted around in the documentation, but I've found nothing saying this
> is _not_ possible.  Am I missing something here?

No, the docs are missing something. Same with index on numeric. It's on
the TODO list.

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

On Sat, Nov 06, 1999 at 03:26:12PM +0100, Peter Eisentraut wrote:
> On 1999-11-04, Vince Gonzalez mentioned:
> 
> > I'm running 6.5.1 on FreeBSD, and I'm trying to create a table with an
> > array of numerics. I do this:
> > 
> > test=> create table test (num numeric(10,2)[]);
> > 
> > and I get this:
> > 
> > ERROR:  Unable to locate type name '_numeric' in catalog
> > 
> > I've hunted around in the documentation, but I've found nothing saying this
> > is _not_ possible.  Am I missing something here?
> 
> No, the docs are missing something. Same with index on numeric. It's on
> the TODO list.

Okay, so I guess my best bet would be to use the money type for the time 
being.  How difficult will it be to move to numeric when money is finally
deprecated?