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

Thu, 17 Jun 1999 18:30:03 +0900
"Hiroshi Inoue" <Inoue@tpf.co.jp>
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

Wed, 7 Jul 1999 20:32:46 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] creating an index on numeric type