Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: how to index a numeric(12,2) column?
Date
Msg-id 22500.973640915@sss.pgh.pa.us
Whole thread Raw
In response to how to index a numeric(12,2) column?  (Forest Wilkinson <fspam@home.com>)
Responses Re: how to index a numeric(12,2) column?
List pgsql-sql
Tree view 
Forest Wilkinson <fspam@home.com> writes:
> 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.

Uh, what version are you using?  Works fine for me in 7.0.2.
        regards, tom lane

pgsql-sql by date:

Previous
From: Forest Wilkinson
Date:
Subject: how to index a numeric(12,2) column?
Next
From: Mateusz Mazur
Date:
Subject: Table secure problem.