pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [SQL] BUG with decimal type
3+ messages / 3 participants
[nested] [flat]

* Re: [SQL] BUG with decimal type
@ 1999-09-07 21:56  Jan Wieck <wieck@debis.com>
  parent: Jens Glaser <jens@helena.jens.de>
  1 sibling, 0 replies; 3+ messages in thread

From: wieck@debis.com @ 1999-09-07 21:56 UTC (permalink / raw)
  To: jens@jens.de; +Cc: 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) #





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* BUG with decimal type
@ 1999-09-07 22:16  Jens Glaser <jens@helena.jens.de>
  0 siblings, 2 replies; 3+ messages in thread

From: Jens Glaser @ 1999-09-07 22:16 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] BUG with decimal type
@ 1999-09-08 13:32  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Jens Glaser <jens@helena.jens.de>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 1999-09-08 13:32 UTC (permalink / raw)
  To: jens@jens.de; +Cc: pgsql-sql

Jens Glaser <jens@helena.jens.de> writes:
> "ERROR:  Can't find a default operator class for type 1700."

Yeah, there's no support yet for indexes on NUMERIC (DECIMAL) fields :-(.
It's on the TODO list...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1999-09-08 13:32 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-07 22:16 BUG with decimal type Jens Glaser <jens@helena.jens.de>
1999-09-07 21:56 ` Jan Wieck <wieck@debis.com>
1999-09-08 13:32 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox