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@sundog.larc.nasa.gov>
To: <pgsql-general@postgresql.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@sundog.larc.nasa.gov
>
>