On 06/29/2013 09:02 AM, bhanu udaya wrote:
Duplicate the column with an upper or lowercase version and run all queries against that. CREATE TABLE foo ( id serial PRIMARY KEY, val text, val_lower text ); Index val_lower. Use triggers to keep val and val_lower in sync and discard all attempts to write directly to val_lower. Then all queries would be of the form SELECT id, val FROM foo WHERE val_lower LIKE 'ab%'; Wouldn't want to write every table like this, but if (a) query speed trumps all other requirements and (b) functional index, CITEXT, etc. have all been rejected as not fast enough… --Lee -- Lee Hachadoorian Assistant Professor in Geography, Dartmouth College http://freecity.commons.gc.cuny.edu |
- Re: [GENERAL] Postgres DB crashing Merlin Moncure
- Re: [GENERAL] Postgres DB crashing Alan Hodgson
- Re: [GENERAL] Postgres DB crashing Tom Lane
- [GENERAL] Postgres case insensitive searches bhanu udaya
- Re: [GENERAL] Postgres case insensitive searches Albe Laurenz
- Re: [GENERAL] Postgres case insensitive searches bhanu udaya
- Re: [GENERAL] Postgres case insensitive sear... John R Pierce
- Re: [GENERAL] Postgres case insensitive sear... Alban Hertroys
- Re: [pgadmin-support] [GENERAL] Postgres... bhanu udaya
- Re: [pgadmin-support] [GENERAL] Pos... Alban Hertroys
- Re: [GENERAL] Postgres case insensi... Lee Hachadoorian
- Re: [pgadmin-support] [GENERAL] Pos... bhanu udaya
- Re: [GENERAL] Postgres case insensitive sear... Albe Laurenz
- Re: [GENERAL] Postgres case insensitive ... Ingmar Brouns
- Re: [GENERAL] Postgres case insensi... Albe Laurenz
- Re: [GENERAL] Postgres case insensitive searches Joshua D. Drake
- Re: [GENERAL] Postgres case insensitive searches bhanu udaya
- Re: [GENERAL] Postgres case insensitive sear... John R Pierce
- Re: [GENERAL] Postgres case insensitive sear... Joshua D. Drake
- Re: [pgadmin-support] [GENERAL] Postgres... Michael Shapiro
- Re: [GENERAL] Postgres case insensitive sear... Neil Tiffin