Pastie Support Pastie or read my Pastie << self blog

class PlacesTsearch < ActiveRecord::Migration
  def self.up
    execute("ALTER TABLE places ADD COLUMN tsearchable tsvector;
             UPDATE places SET tsearchable=to_tsvector('english',coalesce(title_ascii,''));
             CREATE INDEX tsearchable_idx ON places USING gin(tsearchable);")
    execute("VACUUM FULL ANALYZE;")

  end

  def self.down
    remove_column :places, :tsearchable
  end
end