index on an int8 column - Mailing list pgsql-general

From Sarah Officer
Subject index on an int8 column
Date
Msg-id 372F75FF.F413913C@aries.tucson.saic.com
Whole thread Raw
List pgsql-general
I have a table with a column of type int8.  When I try to create an
index on it, the
database protests and gives the following error message:

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

Is there an easy fix for this?  I assumed builtin numeric types would
have
default comparison functions.

Also, if I am not posting to the appropriate mailing list, please let me
know.

Thanks in advance,

Sarah Officer
officers@aries.tucson.saic.com



pgsql-general by date:

Previous
From: Mike Haberman
Date:
Subject: ...
Next
From: Dirk Elmendorf
Date:
Subject: 8k Tuple limit