Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group