Postgres Pro
Downloads
Home   >   mailing lists

case insensitive like searches - Mailing list pgsql-admin

From Mark Dueck
Subject case insensitive like searches
Date
Msg-id 49E3614F.7050307@dueck.bz
Whole thread Raw
In response to Re: Finding out on exactly what I am stuck  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: case insensitive like searches  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-admin
Tree view 
Is there a way to make Postgres do case insensitive like searches?  I
know you can use ilike instead, but I don't have control of the
software.  Is there a plan to enable this in the future?

Can I recompile Postgres to make like searches do the same as ilike, or
is it easier to create a new character encoding that will be case
insensitive?

Thanks,
Mark

pgsql-admin by date:

Previous
From: Benjamin Minshall
Date:
Subject: Backup only changed databases
Next
From: Kenneth Marshall
Date:
Subject: Re: case insensitive like searches