Re: Searching case insensitive

[prev] [thread] [next] [Date index for 2005/06/10]

On Fri, Jun 10, 2005 at 11:13:42PM +0200, Wijnand Wiersma wrote:
> > > sub search_ilike { shift->_do_search(ILIKE => @_) }
> Sorry, I forgot to mention. I use Postgres.

I don't think Pg has "ILIKE". Google seems to imply you use ~= so you
probably want:

	sub search_ilike { shift->_do_search("~=" => @_) }

Possibly worth adding either the code or the documentation to
Class::DBI::Pg if so (and certainly to the wiki)

Tony