>
> > 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

Reply via email to