Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] INDEX broken on NUMERIC type. - Mailing list pgsql-bugs

From Christof Petig
Subject Re: [BUGS] INDEX broken on NUMERIC type.
Date
Msg-id 37F0613E.21428264@wtal.de
Whole thread Raw
In response to Re: [BUGS] INDEX broken on NUMERIC type.  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-bugs
Tree view 
> > 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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [BUGS] 'Default' troubles again. This time with time :)))
Next
From: "Srishti Software Pvt. Ltd."
Date:
Subject: clarifications needed on postgres/perl