Can't create an index on NUMERIC(x,y)

Поиск
Список
Период
Сортировка
От secret
Тема Can't create an index on NUMERIC(x,y)
Дата
Msg-id 3834249B.4EBCAA4@kearneydev.com
обсуждение исходный текст
Ответы Re: [SQL] Can't create an index on NUMERIC(x,y)
Список pgsql-sql
ftc=> create index z_test on z(a);
ERROR:  Can't find a default operator class for type 1700.
ftc=> \d z
Table    = z
+----------------------------------+----------------------------------+-------+

|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-------+

| a                                | numeric                          |
9.3  |
+----------------------------------+----------------------------------+-------+

As you can see above when I try to create an index on a NUMERIC it can't
find the default operator for type xxx, is there a way to fix this?  It
hasn't worked since numerics were revised in (6.0?)...

Any advise would be very appreciated, please cc: secret@kearneydev.com
not just the list :)

--David



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

Предыдущее
От: Mario Olimpio de Menezes
Дата:
Сообщение: please help me on pl/pgsql triggers (fwd)
Следующее
От: wieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [SQL] Can't create an index on NUMERIC(x,y)