another DECIMAL problem
| От | José Soares |
|---|---|
| Тема | another DECIMAL problem |
| Дата | |
| Msg-id | 37AFDD39.E3986E@sferacarta.com обсуждение исходный текст |
| Ответы |
Re: [HACKERS] another DECIMAL problem
|
| Список | pgsql-hackers |
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_headerPRIMARY 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. ----------------------------------------------------------------------- PostgreSQL 6.5.0 on i586-pc-linux-gnulibc1, compiled by gcc 2.7.2.1 José
В списке pgsql-hackers по дате отправления: