gistfile1.ru

module Search
  VECTORS = [
    {:klass => Company, :columns => ['ticker', 'name']},
    {:klass => Executive, :columns => ['name']}
  ]
  class << self
    def find(query)
      query = query.split(' ').join(' & ')
      return Search::VECTORS.collect{|tuple|
        Array(tuple[:columns]).collect{|column|
          tuple[:klass].find(:all,
            :conditions => [
              %Q[to_tsvector('english', #{column}) @@ to_tsquery(?)], query
            ]
          )
        }
      }.flatten.uniq
    end
  end
end

def Search(query)
  return Search.find(query)
end