> 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