Re: Index Ops supporting money type

"Rich Ryan" <rich(at)usedcars(dot)com> writes:
> Does anyone know if there is an operator class that supports the money data
> type?

There is not.

Type money is on its way out anyway, at least in its current
incarnation, because it's (a) nonstandard, (b) doesn't support
a reasonable number of digits, and (c) isn't internationalizable.
While (a) is not a fatal objection, (b) and (c) mean the type is
pretty badly crippled.

I doubt that anyone will want to do any work on money in its present
form. Sooner or later it ought to be reimplemented as an I/O skin
on type "numeric" ... hopefully with decent locale support. In the
meantime, efforts like adding index support seem like throwing good
work after bad.

I suggest using type numeric for now.

regards, tom lane