Re: case insensitive matching

Regular expression operator, ~* (Can't use indexes)

You can still use LIKE but you have to do it like :

SELECT * FROM names WHERE lower(firstname) LIKE lower('Mitch');

If you wanted to make this use indexes, you could create the index using
lower(fieldname) .. Something like :

CREATE INDEX on names lower(firstname)

Good luck!

-Mitch

----- Original Message -----
From: "Robert Kernell" <kernell(at)sundog(dot)larc(dot)nasa(dot)gov>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, October 03, 2000 9:41 AM
Subject: [GENERAL] case insensitive matching

> Hi. LIKE does case sensitive string matching. Is there an easy way to do
case
> insensitive string matching?
>
> Bob Kernell
> Research Scientist
> AS&M
> email: kernell(at)sundog(dot)larc(dot)nasa(dot)gov
>
>