postgresql 7.1 select p.product_name, p.product_id, p.dirname, p.one_line_description, pseudo_contains(coalesce(p.product_name, '') || coalesce(p.one_line_description, '') || coalesce(p.detailed_description, '') || coalesce(p.search_keywords,''), :search_text) as score from ec_products_searchable p, ec_category_product_map c where c.category_id=:category_id and p.product_id=c.product_id and pseudo_contains(coalesce(p.product_name, '') || coalesce(p.one_line_description, '') || coalesce(p.detailed_description, '') || coalesce(p.search_keywords,''), :search_text) > 0 order by score desc select p.product_name, p.product_id, p.dirname, p.one_line_description, pseudo_contains(coalesce(p.product_name, '') || coalesce(p.one_line_description, '') || coalesce(p.detailed_description, '') || coalesce(p.search_keywords,''), :search_text) as score from ec_products_searchable p, ec_subcategory_product_map c where c.subcategory_id=:subcategory_id and p.product_id=c.product_id and pseudo_contains(coalesce(p.product_name, '') || coalesce(p.one_line_description, '') || coalesce(p.detailed_description, '') || coalesce(p.search_keywords,''), :search_text) > 0 order by score desc select p.product_name, p.product_id, p.dirname, p.one_line_description, pseudo_contains(coalesce(p.product_name, '') || coalesce(p.one_line_description, '') || coalesce(p.detailed_description, '') || coalesce(p.search_keywords,''), :search_text) as score from ec_products_searchable p where pseudo_contains(coalesce(p.product_name, '') || coalesce(p.one_line_description, '') || coalesce(p.detailed_description, '') || coalesce(p.search_keywords,''), :search_text) > 0 order by score desc