Re: Postgres case insensitive searches

On 6/29/2013 9:24 AM, bhanu udaya wrote:
> Upper and Lower functions are not right choice when the table is > 2.5
> million and where we also have heavy insert transactions.
>
> I doubt, if we can cache the table if there are frequent
> inserts/updates.  The good idea would be to get the DB to case
> insenstive configuration like SQL Server. I would go for this
> solution, if postgres supports.

you need an INDEX on lower(field) or upper(field).   this is only
computed when values are inserted.

if you like a specific feature of SQL Server, then by all means, use SQL
Server.   postgres does not and will not support automatic case
insensitive data.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast