Re: [HACKERS] Index Ops supporting money type

2000-10-18 Thread Tom Lane
"Rich Ryan" <[EMAIL PROTECTED]> 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, a

[HACKERS] Index Ops supporting money type

2000-10-18 Thread Rich Ryan
Does anyone know if there is an operator class that supports the money data type? When I issue a command like : create index "table1_price_idx" on "table" using btree ("price" "money_ops"); or create index "table1_price_idx" on "table" using btree ("price" "float8_ops"); I get errors like : ERROR: