Re: [pgadmin-support] [GENERAL] Postgres case insensitive searches

2013-06-29 Thread Alban Hertroys
this capability (Postgres makes use of the OS collation mechanics). So, what OS are you running the server on? > > From: laurenz.a...@wien.gv.at > > To: udayabhanu1...@hotmail.com; pgsql-gene...@postgresql.org > > Subject: RE: Postgres case insensitive searches > > Date:

Re: [pgadmin-support] [GENERAL] Postgres case insensitive searches

2013-06-29 Thread Alban Hertroys
On Jun 29, 2013, at 15:02, bhanu udaya 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