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 по дате отправления: