pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedarrays of numeric?
3+ messages / 2 participants
[nested] [flat]
* arrays of numeric?
@ 1999-11-05 01:55 Vince Gonzalez <vince@nycrc.net>
1999-11-06 14:26 ` Re: [SQL] arrays of numeric? Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 3+ messages in thread
From: Vince Gonzalez @ 1999-11-05 01:55 UTC (permalink / raw)
To: pgsql-sql@hub.org
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] arrays of numeric?
1999-11-05 01:55 arrays of numeric? Vince Gonzalez <vince@nycrc.net>
@ 1999-11-06 14:26 ` Peter Eisentraut <peter_e@gmx.net>
1999-11-07 19:59 ` Re: [SQL] arrays of numeric? Vince Gonzalez <vince@nycrc.net>
0 siblings, 1 reply; 3+ messages in thread
From: Peter Eisentraut @ 1999-11-06 14:26 UTC (permalink / raw)
To: Vince Gonzalez <vince@nycrc.net>; +Cc: pgsql-sql@hub.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] arrays of numeric?
1999-11-05 01:55 arrays of numeric? Vince Gonzalez <vince@nycrc.net>
1999-11-06 14:26 ` Re: [SQL] arrays of numeric? Peter Eisentraut <peter_e@gmx.net>
@ 1999-11-07 19:59 ` Vince Gonzalez <vince@nycrc.net>
0 siblings, 0 replies; 3+ messages in thread
From: Vince Gonzalez @ 1999-11-07 19:59 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-sql@hub.org
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-11-07 19:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-11-05 01:55 arrays of numeric? Vince Gonzalez <vince@nycrc.net>
1999-11-06 14:26 ` Peter Eisentraut <peter_e@gmx.net>
1999-11-07 19:59 ` Vince Gonzalez <vince@nycrc.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox