Re: [SQL] BUG with decimal type

From: wieck(at)debis(dot)com (Jan Wieck)
To: jens(at)jens(dot)de
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] BUG with decimal type
Date: 1999-09-07 21:56:33
Message-ID: m11OTE9-0003kLC@orion.SAPserv.Hamburg.dsh.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."

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(at)debis(dot)com (Jan Wieck) #

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jens Glaser 1999-09-07 22:16:14 BUG with decimal type
Previous Message leonardo albrizio 1999-09-07 20:26:47 (no subject)