Re: [SQL] Most efficient way to achieve this ts_query

On 10/16/08, Frank Bax <[EMAIL PROTECTED]> wrote: > Jamie Tufnell wrote: >> 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

Re: [SQL] Most efficient way to achieve this ts_query

Jamie Tufnell wrote: 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 s

[SQL] Most efficient way to achieve this ts_query

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 col