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: 22500.973640915@sss.pgh.pa.us (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group