Bloom index for bigint

[obartunov]

Bloom index by default works for int4 and text, but other types with hash function and equality operator could be supported. Just use opclass interface, for example, for type bigint

CREATE OPERATOR CLASS bigint_ops
DEFAULT FOR TYPE bigint USING bloom AS
OPERATOR 1 =(bigint, bigint),
FU>CTION 1 hashint8(bigint);
Now, you can

Comments

[aelein]

Oleg,
What exactly is a bloom index? Is it a particular type of a hash function?

Hope all is well with you.

Elein
elein@varlena.com