Re: [HACKERS] another DECIMAL problem

[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