Re: [SQL] BUG with decimal type - Mailing list pgsql-sql

From wieck@debis.com (Jan Wieck)
Subject Re: [SQL] BUG with decimal type
Date
Msg-id m11OTE9-0003kLC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to BUG with decimal type  (Jens Glaser <jens@helena.jens.de>)
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."


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

pgsql-sql by date:

Previous
From: Jens Glaser
Date:
Subject: BUG with decimal type
Next
From: Hroi Sigurdsson
Date:
Subject: DEFAULT confusion