Re: [GENERAL] Multicolumn index including tsvector.

2009-11-23 Thread Kris Gale
> > > explain analyze select body from example where user_id=1 and vectors @@ > > to_tsquery('simple', 'when') limit 10; > > Try coercing the '1' to a bigint. I don't believe the btree_gist > opclasses have any support for cross-type operators. > Perfect! Thanks, Tom. The query plan now shows i

[GENERAL] Multicolumn index including tsvector.

2009-11-23 Thread Kris Gale
Hi everyone, In the documentation and past messages to this list, it sounds like the btree_gist and btree_gin modules included in contrib/ in 8.4 should give me the functionality I'm looking for, but I don't seem to be getting the behavior I want. I've made an example table representing something