Forest Wilkinson <fspam(at)home(dot)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