ts_tovector() to_query() - Mailing list pgsql-general

From Severn, Chris
Subject ts_tovector() to_query()
Date
Msg-id 93EDA2D7FDE4774AB8258B97B8599D3802DB2313@gold.intra.chernay.com
Whole thread Raw
Responses Re: ts_tovector() to_query()
Re: ts_tovector() to_query()
List pgsql-general

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

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Money casting too liberal?
Next
From: Jasen Betts
Date:
Subject: Re: Money casting too liberal?