pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
arrays 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