From: | Vince Gonzalez <vince(at)nycrc(dot)net> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-sql(at)hub(dot)org |
Subject: | Re: [SQL] arrays of numeric? |
Date: | 1999-11-07 19:59:42 |
Message-ID: | 19991107145941.A17780@moe.nycrc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 1999-11-08 00:32:26 | RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) |
Previous Message | Adrian Alb | 1999-11-07 12:23:26 | unsubscribe |