From: | Yann Ramin <atrus(at)atrustrivalie(dot)eu(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Case insensitive LIKE queries |
Date: | 2000-11-01 05:05:05 |
Message-ID: | 00103121050502.02479@atp.atpn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
What would be the most effective way of preforming a case-insensitive LIKE
query? I've notived that MySQL somehow ALWAYS does it case insensitive,
which is not very smart, but I should expect this feature to exist without
reasonable pain on the programmer;s end?
Yann
--
--------------------------------------------------------------------
Yann Ramin atrus(at)atrustrivalie(dot)eu(dot)org
Atrus Trivalie Productions www.redshift.com/~yramin
AIM oddatrus
Marina, CA http://profiles.yahoo.com/theatrus
IRM Developer Network Toaster Developer
SNTS Developer KLevel Developer
Electronics Hobbyist person who loves toys
Build a man a fire, and he's warm for a day.
Set a man on fire, and he'll be warm for the rest of his life.
"I'm prepared for all emergencies but totally unprepared for everyday
life."
--------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Dave | 2000-11-01 05:15:59 | How to configure pgsql to store chinese? |
Previous Message | Igor Roboul | 2000-11-01 04:58:04 | Re: SQL question - problem with INTERSECT |