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: DefineIndex: opclass "money_ops" not found
and
ERROR: DefineIndex: opclass "float8_ops" does not accept datatype "money"
respectively.
I looked everywhere for documentation about this, and asked this question
elsewhere, but nobody knew anything.
Thanks in advance.
Rich Ryan