That doesn't address the lower(name) portion of the question, just the part where it specifies btree. Any idea how to do the lowercase portion?
On Wednesday, July 3, 2013 2:30:38 PM UTC-4, Rick wrote: > > 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) -- > PostgreSQLCREATE 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+unsubscr...@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/7e793c66-22d6-4270-86c3-580ed226e719%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.