| From: | Oleg Broytmann <phd(at)sun(dot)med(dot)ru> |
|---|---|
| To: | Mike Barnes <strepsil(at)very(dot)net> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Case insensitive searches? |
| Date: | 1999-04-12 13:50:17 |
| Message-ID: | Pine.SOL2.3.96.SK.990412174656.12781A-100000@sun.med.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi!
On Mon, 12 Apr 1999, Mike Barnes wrote:
> Hiho ... I'd really like to know if anyone has any good suggestions for
> performing case insensitive searches on data in a 6.3 server using Perl. If
> there's some really obvious solution I'm missing, please club me over the
> head with it.
Make all things lowercase:
SELECT * FROM mytable WHERE lower(mycolumn) = 'mylowercasedata'
For regexp searching use ~* (case insensitive regexp).
> Mike.
>
>
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeffrey MacDonald | 1999-04-12 13:56:27 | Re: Case insensitive searches? |
| Previous Message | Mike Barnes | 1999-04-12 13:35:31 | Case insensitive searches? |