pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [SQL] BUG with decimal type
3+ messages / 3 participants
[nested] [flat]
* BUG with decimal type
@ 1999-09-07 22:16 Jens Glaser <jens@helena.jens.de>
1999-09-07 21:56 ` Re: [SQL] BUG with decimal type Jan Wieck <wieck@debis.com>
1999-09-08 13:32 ` Re: [SQL] BUG with decimal type Tom Lane <tgl@sss.pgh.pa.us>
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-07 22:16 BUG with decimal type Jens Glaser <jens@helena.jens.de>
@ 1999-09-07 21:56 ` Jan Wieck <wieck@debis.com>
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
* Re: [SQL] BUG with decimal type
1999-09-07 22:16 BUG with decimal type Jens Glaser <jens@helena.jens.de>
@ 1999-09-08 13:32 ` Tom Lane <tgl@sss.pgh.pa.us>
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