how to index a numeric(12,2) column? - Mailing list pgsql-sql

From Forest Wilkinson
Subject how to index a numeric(12,2) column?
Date
Msg-id h22h0tcl0au01o1c0oed7dinlc7n8kqasj@4ax.com
Whole thread Raw
Responses Re: how to index a numeric(12,2) column?
List pgsql-sql
I'd like to create an index on a column whose type is NUMERIC(12,2).
There appears to be no default operator class for the numeric type.  What
class should I use instead?  My guess is that something like this might
work:

CREATE INDEX foo_idx on foo (bar int8_ops);

Will that work properly?  Will it do me any good?  Is there a better way?




pgsql-sql by date:

Previous
From: Larry Rosenman
Date:
Subject: Display of RI triggers
Next
From: Tom Lane
Date:
Subject: Re: how to index a numeric(12,2) column?