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
CREATE INDEX index_developers_on_name ON developers USING btree (name)
– PostgreSQLCREATE INDEX index_developers_on_name USING btree ON
developers (name) – MySQL
CREATE INDEX index_developers_on_name ON developers USING btree (name)
– PostgreSQLCREATE INDEX index_developers_on_name USING btree ON
developers (name) – MySQL