[Rails] Re: Create lowercase index

Direct from Rails4.0 ActiveRecord documentation:

Creating an index with a specific method

add_index(:developers, :name, using: 'btree')

generates:

CREATE INDEX index_developers_on_name ON developers USING btree (name) -- PostgreSQL  CREATE INDEX index_developers_on_name USING btree ON developers (name) -- MySQL

Note: only supported by PostgreSQL and MySQL

On Tuesday, July 2, 2013 1:13:15 PM UTC-4, Linus Pettersson wrote:

Hi

I'm sorting some columns like this: MyModel.order("LOWER(column) ASC")... But these queries are quite slow. I'm on Postgres by the way.

Does Rails support creating a lowercase index for these situations? I know Postgres has support for it and I guess I can create one like this (found on SO):

execute "CREATE UNIQUE INDEX index_products_on_lower_name ON products USING btree (lower(name));"

But does Rails have support for creating it? Don't like to use execute() if there is a better way :)

Cheers,

Linus

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/c2f87267-c2ef-42ac-a66e-951ce8a566e5%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.