> > > 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 it considering both columns in the index condition. Kris