Forum: Ruby on Rails RE: Rails + postgres case insensitive searches.

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Berger, Daniel (Guest)
on 2006-04-24 20:02
(Received via mailing list)
> > 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.
>
> Robby

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

Regards,

Dan


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