I have a statement that is like this
SELECT m.* FROM movies m WHERE to_tsvector(m.item_title) @@
to_tsquery('Robocop|DVD|Collection')
this works, but it correctly returns all the matching records that have any of
the query items in them.
What I want to do is return items that have 'Robocop' or 'Robocop and DVD' or
'Robocop and Collection' or 'Robocop and DVD and collection'
is there an operator for the tsvector / tsquery relationship that will do this?
Or am I forced to sift through the results of the initial query after the fact?
Thanks,
Chris
