Re: case insensitive search

SELECT whatever FROM wherever WHERE lower(yourfield) = 'this';

You can do it with a case inseneitive regex search but they can't use
indexes and can become very slow on large tables..

SELECT whatever FROM wherever WHERE yourfield ~* 'this';

lower() does leak a bit of memory from what I've heard on the list but I'm
sure someone is working on it..

-Mitch

----- Original Message -----
From: Joern Muehlencord <jomu(at)uni-paderborn(dot)de>
To: gpsql-sql <pgsql-sql(at)postgresql(dot)org>
Sent: Monday, June 26, 2000 2:14 PM
Subject: [SQL] case insensitive search

> Hello together,
>
> how can I handle case insensitive search in a table?
>
>
>
> --
> Linux is like wigwam - no windows, no gates, apache inside.
> In diesem Sinne
> Joern
>
>
>