User can enter any number of words as search string.
In shopping cart the following query is used to find products,
eq. if "red cat" is entered:
select * from products
where productname ilike '%'||'red cat'||'%'
or productdescription ilike '%'||'red cat'||'%'
limit 100
This does not find products like "red or black cat".
How to change this query so that it returns 100 best matches for for given search string?
I read documentaton about full text search but havent found step by step solution for this.
Using PostgreSQL 8.2.7 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
Should I install some contribs to 8.2 or is it better to upgrade server ?
Where to find step by step instructions making this work ?
Andrus.