| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Case in-sensitive |
| Date: | 2002-07-23 14:46:33 |
| Message-ID: | 20020723104633.E23294@mail.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Tue, Jul 23, 2002 at 02:35:40PM +0000, Carmen Wai wrote:
> Hello:
>
> Can I config the Postgresql so that it can match case in-sensitive pattern
> automatically? i.e. I don't need to explicit convert the pattern to lower
> case like this: .....WHERE lower(textfield) LIKE lower(pattern)
No. But you can use ILIKE, which is a case-insensitive LIKE.
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carmen Wai | 2002-07-23 14:53:10 | No command history in psql |
| Previous Message | Craig Sturman | 2002-07-23 14:40:25 | time setting |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carmen Wai | 2002-07-23 14:53:10 | No command history in psql |
| Previous Message | Carmen Wai | 2002-07-23 14:35:40 | Case in-sensitive |