You are an expert in writing code in many different languages. Your goal is to perform code completion for the following code, keeping in mind the rest of the code and the file meta data.
    Metadata details:
    filename: 20231107193342_add_search_vector_to_catalog_resources.rb
    path of file: ./repos/gitlabhq/db/migrate
    
    the code of the file until where you have to start completion: # frozen_string_literal: true

class AddSearchVectorToCatalogResources < Gitlab::Database::Migration[2.2]
  milestone '16.7'

  def up
    # This is required to implement PostgreSQL Full Text Search functionality in Ci::Catalog::Resource.
    # Indices on `search_vector` will be added in a later step. COALESCE is us
    
  def up
    # This is required to implement PostgreSQL Full Text Search functionality in Ci::Catalog::Resource.
    # Indices on `search_vector` will be added in a later step. COALESCE is used here to avoid NULL results.
    # See https://gitlab.com/gitlab-org/gitlab/-/issues/430889 for details.
    execute <<~SQL
      ALTER TABLE catalog_resources
        ADD COLUMN search_vector tsvector
          GENERATED ALWAYS AS
            (setweight(to_tsvector('english', COALESCE(name, '')), 'A') ||
             setweight(to_tsvector('english', COALESCE(description, '')), 'B')) STORED;
    SQL
  end