RE: Rails + postgres case insensitive searches

I was really hoping to avoid such a thing if at all
name.downcase]) end
find( :all, :conditions => [ ‘name ~* ?’, name ] )

I’m pretty sure that by using a regex… it’ll use the index.


And, if not, you can always setup an expression index for
the lower() function on columns where you regularly do that. :slight_smile:



This communication is the property of Qwest and may contain confidential
privileged information. Unauthorized use of this communication is
prohibited and may be unlawful. If you have received this communication
in error, please immediately notify the sender by reply e-mail and
all copies of the communication and any attachments.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs