Re: how to index a numeric(12,2) column? - Mailing list pgsql-sql

From Tom Lane
Subject Re: how to index a numeric(12,2) column?
Date
Msg-id 3133.973710386@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to index a numeric(12,2) column?  (Forest Wilkinson <fspam@home.com>)
List pgsql-sql
Forest Wilkinson <fspam@home.com> writes:
> Sorry; I hit send before adding that information.  I'm using postgres
> 6.5.3 on i386 Red Hat 6.1.

Time to update, then.

> It allows me to create an index on a NUMERIC(12,2) field using the
> int8_ops class, but I'm wondering if this might have some undesirable
> hidden side effects.

Yes, and they won't be too hidden either: it won't work :-(

Current sources check for that sort of type mismatch, but 6.5 failed to
do so.
        regards, tom lane


pgsql-sql by date:

Previous
From: Forest Wilkinson
Date:
Subject: Re: how to index a numeric(12,2) column?
Next
From:
Date:
Subject: ./configure problems