From: | José Soares <jose(at)sferacarta(dot)com> |
---|---|
To: | hackers <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | another DECIMAL problem |
Date: | 1999-08-10 08:05:13 |
Message-ID: | 37AFDD39.E3986E@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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_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.
-----------------------------------------------------------------------
PostgreSQL 6.5.0 on i586-pc-linux-gnulibc1, compiled by gcc 2.7.2.1
José
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim Mikheev | 1999-08-10 10:40:59 | Re: [HACKERS] WAL: parallel logging |
Previous Message | lamar.owen | 1999-08-10 04:03:14 | Re: RPMs (was Pronunciation of "PostgreSQL") |