Received: from moe.nycrc.net (gabriel.nycrc.net [209.73.202.66]) by hub.org (8.9.3/8.9.3) with SMTP id OAA67285 for ; Sun, 7 Nov 1999 14:59:46 -0500 (EST) (envelope-from vince@nycrc.net) Received: (qmail 17804 invoked by uid 1001); 7 Nov 1999 19:59:42 -0000 Date: Sun, 7 Nov 1999 14:59:42 -0500 From: Vince Gonzalez To: Peter Eisentraut Cc: pgsql-sql@hub.org Subject: Re: [SQL] arrays of numeric? Message-ID: <19991107145941.A17780@moe.nycrc.net> References: <19991104205536.A10081@moe.nycrc.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.4i In-Reply-To: ; from Peter Eisentraut on Sat, Nov 06, 1999 at 03:26:12PM +0100 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?