Most efficient way to achieve this ts_query - Mailing list pgsql-sql

From Jamie Tufnell
Subject Most efficient way to achieve this ts_query
Date
Msg-id b0a4f3350810151800i529d734bld19b6fc3487309f8@mail.gmail.com
Whole thread Raw
Responses Re: Most efficient way to achieve this ts_query  (Frank Bax <fbax@sympatico.ca>)
List pgsql-sql
Hi

If someone uses a search query on my site like this:

"abc def"

I would like to return all results for 'abc & def' first, followed by
all results for tsquery 'abc | def' is there some way to express this
in one tsquery?  What's the most efficient way to go about this?  The
search is on one column.

Thanks
Jamie


pgsql-sql by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Updating Query of 1 table from data in another
Next
From: Frank Bax
Date:
Subject: Re: Most efficient way to achieve this ts_query