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
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 |