Re: [pgadmin-support] Postgres case insensitive searches

Alban Hertroys <haramrae@gmail.com>

From: Alban Hertroys <haramrae@gmail.com>
To: bhanu udaya <udayabhanu1984@hotmail.com>
Cc: Albe Laurenz <laurenz.albe@wien.gv.at>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>, "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Date: 2013-06-29T13:54:04Z
Lists: pgsql-general
On Jun 29, 2013, at 15:02, bhanu udaya <udayabhanu1984@hotmail.com> wrote:

> I agree that it is just search condition. But, in a 2.5 million record table search, upper function is not that fast.  

Suit yourself, the solution is there.

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.