How to do case-insensitive order in Rails with postgresql
- by brad
I am in the process of switching my development environment from sqlite3 to postgresql 8.4 and have one last hurdle.
In my original I had the following line in a helper method;
result = Users.find(:all, :order => "name collate NOCASE")
which provided a very nice case-insensitive search. I can't replicate this for postgresql. Should be easy - any ideas?
Thanks.