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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to