Index Ops supporting money type - Mailing list pgsql-hackers

From Rich Ryan
Subject Index Ops supporting money type
Date
Msg-id 04e401c03988$a2e92de0$05010a0a@usedcars.com
Whole thread Raw
In response to Solaris FAQ  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Index Ops supporting money type
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: SetQuerySnapshot() for utility statements
Next
From: Tom Lane
Date:
Subject: Re: Index Ops supporting money type