Обсуждение: creating an index on numeric type

Hi all,

I couldn't create a table which has a primary key on numeric type.

create table t (id numeric(7,2) primary key);
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
't_pkey' for table 't'
ERROR:  Can't find a default operator class for type 1700. 

How can I create an index on numeric type ? 

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp

Added to TODO:
* Add index on NUMERIC type 

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026