gistfile1.txt

module PgSearchable

  def self.included(base)
    base.extend(ClassMethods)
  end

  module ClassMethods
    def searchable_on(*args)
      @@search_columns = args
    end
    
    def pg_search(terms = nil)
      return self.scoped if terms.blank?

      document = @@search_columns.join(" || ' ' || ")
      query = terms.split.map{|term| "#{term}:*"}.join(" & ")
      where("to_tsvector(#{document}) @@ to_tsquery(?)", query)
    end
  end

end