Re: [BUGS] INDEX broken on NUMERIC type.

Christof Petig <christof.petig@wtal.de>

From: Christof Petig <christof.petig@wtal.de>
To: pgsql-bugs@postgresql.org, mschout@gkg.net
Date: 1999-09-28T06:33:34Z
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