another DECIMAL problem

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é

Responses

Browse pgsql-hackers by date

  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")