creating an index on numeric type

Started by Hiroshi Inoueover 26 years ago2 messages

Inoue@tpf.co.jp

over 26 years ago

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

Bruce Momjian

maillist@candle.pha.pa.us

over 26 years ago

In reply to: Hiroshi Inoue (#1)

Re: [HACKERS] creating an index on numeric type

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, Pennsylvania 19026