Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id SAA09624 for ; Tue, 7 Sep 1999 18:00:45 -0400 (EDT) (envelope-from wieck@debis.com) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m11OTE9-0003kLC; Tue, 7 Sep 99 23:56 MET DST Message-Id: From: wieck@debis.com (Jan Wieck) Subject: Re: [SQL] BUG with decimal type To: jens@jens.de Date: Tue, 7 Sep 1999 23:56:33 +0200 (MET DST) Cc: pgsql-sql@postgreSQL.org Reply-To: wieck@debis.com (Jan Wieck) In-Reply-To: from "Jens Glaser" at Sep 7, 99 10:16:14 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > 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." Not fixed - but well known. Jan PS: I'm not dead. The problem is that there are not only priorities on my TODO's. They are organized in separate lists where each list has a master-priority. -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #========================================= wieck@debis.com (Jan Wieck) #