Received: from merganser.its.uu.se (merganser.its.uu.se [130.238.6.236]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA60364 for ; Sat, 6 Nov 1999 10:41:55 -0500 (EST) (envelope-from peter@peter-e.yi.org) Received: from uria.its.uu.se ([130.238.7.14]:4447 "EHLO peter-e.yi.org") by merganser.its.uu.se with ESMTP id ; Sat, 6 Nov 1999 16:41:49 +0100 Received: from peter (helo=localhost) by peter-e.yi.org with local-esmtp (Exim 3.02 #2) id 11k6nE-0000HX-00; Sat, 06 Nov 1999 15:26:12 +0100 Date: Sat, 6 Nov 1999 15:26:12 +0100 (CET) From: Peter Eisentraut To: Vince Gonzalez cc: pgsql-sql@hub.org Subject: Re: [SQL] arrays of numeric? In-Reply-To: <19991104205536.A10081@moe.nycrc.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: Peter Eisentraut 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