Re: [SQL] arrays of numeric? - Mailing list pgsql-sql

From Vince Gonzalez
Subject Re: [SQL] arrays of numeric?
Date
Msg-id 19991107145941.A17780@moe.nycrc.net
Whole thread Raw
In response to Re: [SQL] arrays of numeric?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
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?


pgsql-sql by date:

Previous
From: "Adrian Alb"
Date:
Subject: unsubscribe
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?)