BUG with decimal type - Mailing list pgsql-sql

From Jens Glaser
Subject BUG with decimal type
Date
Msg-id Pine.LNX.4.05.9909072211080.3922-100000@helena.jens.de
Whole thread Raw
Responses Re: [SQL] BUG with decimal type  (wieck@debis.com (Jan Wieck))
Re: [SQL] BUG with decimal type  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@jens.de



pgsql-sql by date:

Previous
From: leonardo albrizio
Date:
Subject: (no subject)
Next
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] BUG with decimal type