Index on int8

Поиск
Список
Период
Сортировка
От Michael Contzen
Тема Index on int8
Дата
Msg-id 36432941.C9A8045A@dohle.com
обсуждение исходный текст
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: A James Lewis
Дата:
Сообщение: Re: [GENERAL] timespan
Следующее
От: Adriaan Joubert
Дата:
Сообщение: pg_hba.conf woes