[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hi all,
>
> I'm trying to create an index on a composite key using a DECIMAL type
> but PostgreSQL raises the following error:
>
>
> CREATE TABLE header (
> year decimal(4) NOT NULL,
> number INTEGER NOT NULL,
> date DATE NOT NULL,
> cod_client CHAR(4) NOT NULL,
> CONSTRAINT k_header PRIMARY KEY (year,number)
> );
> NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'k_header'
> for tabl
> e 'header'
> ERROR: Can't find a default operator class for type 1700.
>
We have the TODO item:
* 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