ssage-
From: dep...@depesz.com [mailto:dep...@depesz.com]
Sent: Friday, March 29, 2013 7:59 AM
To: Severn, Chris
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ts_tovector() to_query()
On Thu, Mar 28, 2013 at 08:50:50PM +, Severn, Chris wrote:
> What I want to do is return items
On Thu, Mar 28, 2013 at 08:50:50PM +, Severn, Chris wrote:
> 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'
Based on the criteria above, I would say that:
SELECT m.* FROM movies m WHERE to_tsvector(m.
On Thu, Mar 28, 2013 at 2:12 PM, Kevin Grittner wrote:
>> 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'
>
> SELECT m.* FROM movies m
> WHERE to_tsvector(m.item_title) @@ to_tsquery('Robocop & (DVD
"Severn, Chris" wrote:
> 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 t
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