Rails - Mar 2006 - Migrations with multi-column indexes

Hey Folks,

I can''t really glean this from the documentation.  

Is there a way to do: add_index(table_name, column_name, index_type)
within my migration for an index that spans multiple columns?  Ie: A
covering index on FIRST_NAME, LAST_NAME or something like that?

Best,
Brian


---------------------------
Brian Corrigan
---------------------------

Brian

Try

       add_index :people [:id, :first_name, :last_name], :name => 
:people_all, :unique => true

     > Is there a way to do: add_index(table_name, column_name, index_type)
     > within my migration for an index that spans multiple columns?  Ie: A
     > covering index on FIRST_NAME, LAST_NAME or something like that?

Alain