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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026