Re: [SQL] arrays of numeric?

Поиск
Список
Период
Сортировка
От Vince Gonzalez
Тема Re: [SQL] arrays of numeric?
Дата
Msg-id 19991107145941.A17780@moe.nycrc.net
обсуждение исходный текст
Ответ на Re: [SQL] arrays of numeric?  (Peter Eisentraut <peter_e@gmx.net>)
Список 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?


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Adrian Alb"
Дата:
Сообщение: unsubscribe
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?)