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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Forest Wilkinson <fspam(at)home(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: how to index a numeric(12,2) column?
Date: 2000-11-07 23:48:35
Message-ID: 22500.973640915@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Forest Wilkinson <fspam(at)home(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mateusz Mazur 2000-11-08 13:26:54 Table secure problem.
Previous Message Forest Wilkinson 2000-11-07 22:57:59 how to index a numeric(12,2) column?