| From: | "Carmen Wai" <wai_carmen(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Case in-sensitive |
| Date: | 2002-07-23 14:35:40 |
| Message-ID: | F65Ok5zzfEvxhJx5seQ00000046@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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)
Thanks a lot!
Carmen
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2002-07-23 14:35:53 | Re: Stats Collector |
| Previous Message | Andrew Sullivan | 2002-07-23 14:32:08 | Re: High availibility with PostgreSQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2002-07-23 14:46:33 | Re: Case in-sensitive |
| Previous Message | Sandro Joel Eller | 2002-07-23 14:34:09 | Re: Scan SQL |