Re: How to perform full text search

On 03/18/12 11:45 AM, Andrus wrote:
> select
> +case when productname ilike '%red%'  then 2 else 0 end
> +case when productdescription ilike '%red%'  then 1 else 0 end
> +case when productname ilike '%cat%'  then 1.7 else 0 end
> +case when productdescription ilike '%cat%'  then 0.7 else 0 end
> from products
> order by 1 desc
> limit 100
>
> This allows to define relevance.
> Is my solution reasonable ?

if you don't mind a full table sequential scan each time you execute
that, I suppose.

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast