Re: [BUGS] INDEX broken on NUMERIC type.

From: Christof Petig <christof(dot)petig(at)wtal(dot)de>
To: pgsql-bugs(at)postgresql(dot)org, mschout(at)gkg(dot)net
Subject: Re: [BUGS] INDEX broken on NUMERIC type.
Date: 1999-09-28 06:33:34
Message-ID: 37F0613E.21428264@wtal.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> > If you know how this problem might be fixed, list the solution below:
>

CREATE TABLE "bn_summary" (
"maschine" numeric(3,0) NOT NULL);
CREATE INDEX "bn_summary_key0" on "bn_summary" using btree ( "maschine"
"int2_ops" );

works for me, though I don't know if this is recommended.

Regards
Christof

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Srishti Software Pvt. Ltd. 1999-09-28 07:40:40 clarifications needed on postgres/perl
Previous Message Bruce Momjian 1999-09-28 05:03:48 Re: [BUGS] 'Default' troubles again. This time with time :)))