"Jeff Frost" <jeff(at)pgexperts(dot)com> writes:
> Ran into a situation with a customer who is using the btree_gist contrib
> module to allow combined index of some tsearch data and two other columns.
> One of these other columns is a bigint field. I noticed that the combined
> index won't be used by the planner unless you specifically cast the bare
> number to a bigint.
If memory serves, the btree_gist opclasses don't include any cross-type
operators, so "int8 = int4" doesn't work here.
regards, tom lane