BUG with decimal type

From: Jens Glaser <jens(at)helena(dot)jens(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: BUG with decimal type
Date: 1999-09-07 22:16:14
Message-ID: Pine.LNX.4.05.9909072211080.3922-100000@helena.jens.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

sorry if this is already fixed, but under Postgres 6.5.1. (debian 6.5.1-6)
the following ..

create table VAT (
objectid integer not null primary key,
ts integer not null,
vatlevel decimal(18,2) not null,
orderby integer not null
);
create unique index VAT_level_idx on VAT ( vatlevel );

.. yields:

"ERROR: Can't find a default operator class for type 1700."

Regards,

--
Jens Glaser Am Holderstrauch 13, 36041 Fulda, 0661/9429507 jens(at)jens(dot)de

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Hroi Sigurdsson 1999-09-07 23:28:04 DEFAULT confusion
Previous Message Jan Wieck 1999-09-07 21:56:33 Re: [SQL] BUG with decimal type