creating an index on numeric type

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "pgsql-hackers" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: creating an index on numeric type
Date: 1999-06-17 09:30:03
Message-ID: 000b01beb8a3$fa8a4be0$2801007e@cadzone.tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)tpf(dot)co(dot)jp

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message gravity 1999-06-17 09:33:13 (don't know who else to tell) 6.5 gets build on LinuxPPCR5 but fails a lot of regr. tests
Previous Message Gene Sokolov 1999-06-17 07:51:13 Re: [HACKERS] Case tool