Philip Hallstrom
2008-Sep-23 21:22 UTC
Ticket for Review: Patch to support PostgreSQL functional indexes.
Hi all - Ticket is here: http://rails.lighthouseapp.com/projects/8994-ruby-on-rails/tickets/1099-patch-to-support-postgresql-functional-indexes Description: ------------------------------------------------------------------------------------------------------- Attached is a patch (with tests) to add functional index support to postgresql. It is based on the work here: http://devblog.famundo.com/articles/2007/01/29/adding-support-for-functional-indexes-in-rails It lets you do this in a migration: add_index :some_table, :some_column, :functional => "LOWER(some_column)" If the database adapter supports functional indexes (postgresql only with this patch) it will generate a functional index. Otherwise it will ignore that option and generate a default index. The SchemaDumper has also been modified to generate functional indexes on output if appropriate. ------------------------------------------------------------------------------------------------------- Thanks for taking a look! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---