> > I'm trying to create an index on a composite key using a DECIMAL type
> > but PostgreSQL raises the following error:
> > ERROR: Can't find a default operator class for type 1700.
>
> afaik Postgres does not yet implement indices for NUMERIC or DECIMAL.
> Don't know if anyone has plans to do so...
>
> - Thomas
TODO list has:
* Add index on NUMERIC/DECIMAL type
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026