Create lowercase index

Linus Pettersson
2013-07-02T17:13:15Z

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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit