how to index a numeric(12,2) column?

From: Forest Wilkinson <fspam(at)home(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: how to index a numeric(12,2) column?
Date: 2000-11-07 22:57:59
Message-ID: h22h0tcl0au01o1c0oed7dinlc7n8kqasj@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-11-07 23:48:35 Re: how to index a numeric(12,2) column?
Previous Message Indraneel Majumdar 2000-11-07 21:30:51 reinitialise serial counter