| From: | chriswood(at)wvda(dot)com |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | subselect question |
| Date: | 2000-12-11 14:24:28 |
| Message-ID: | 3A34AB5C.13138.6147E1@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
As in an SQL line you'd find in PHP:
select * from mytable where thiscolumn = '%whatever%'
Can I make thiscolumn = '%whatever%' be case-insensitive? I'm
pretty sure I can't, but if there's a way in SQL hints would be
appreciated. I can already do this search via a regular expression,
but that's quite slow and I'd like a better way.
--------------------------------------------------------
Christopher Wood, Community Access Technical Coordinator
Western Valley Development Authority
Nova Scotia's Smart Community
Box 251 Bridgetown, Nova Scotia B0S 1C0
tel: (902) 665-4083/ fax: (902) 665-2878
www.wvda.com www.wvcn.ns.ca
--------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | peter | 2000-12-11 15:23:25 | Re: 7.1beta1 JDBC Nested cursor problem |
| Previous Message | The Hermit Hacker | 2000-12-10 17:15:34 | Re: Re: [BUGS] 7.1beta1 JDBC Nested cursor problem |