Index on int8

From: Michael Contzen <mcontzen(at)dohle(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Index on int8
Date: 1998-11-06 16:52:17
Message-ID: 36432941.C9A8045A@dohle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I just installed v6.4 and it works fine. The type int8 is now available
on Linux without need to use the contrib/int8.

But how can I make an index on int8-fields? Create index returns
create table l (i int8);
create index li on l using btree(i);

ERROR: Can't find a default operator class for type 20.

I just tried add an operator-class and included the 5 comparison
operators in pg_opclass, pg_amop but that seems not to be enough.

Some idea?

An other question: Is there some DECIMAL or fixed-point type of about 13
digits?

Kind regards,

Michael Contzen

Dohle Systemberatung
Germany

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Lo 1998-11-06 18:09:15 PostgreSQL 6.4 problems on Linux.
Previous Message Ulf Mehlig 1998-11-06 13:11:06 Re: [GENERAL] timespan