creating an index on numeric type - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject creating an index on numeric type
Date
Msg-id 000b01beb8a3$fa8a4be0$2801007e@cadzone.tpf.co.jp
Whole thread Raw
Responses Re: [HACKERS] creating an index on numeric type  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Savepoints...
Next
From: gravity
Date:
Subject: (don't know who else to tell) 6.5 gets build on LinuxPPCR5 but fails a lot of regr. tests