Jeff Frost <j...@pgexperts.com> writes: > On 07/05/11 17:06, Tom Lane wrote: >> "Jeff Frost" <j...@pgexperts.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. > Ah! And if you look at the contrib/btree_gist/sql/int8.sql test file, you'll > see this: > SELECT count(*) FROM int8tmp WHERE a < 464571291354841::int8; > So, I'd say it's expected behavior even though it's slightly counter intuitive > if you're used to the auto typing behavior. Well, it might be nice to fix it sometime, but I'd characterize it as an unimplemented feature in btree_gist, not a bug. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs