subselect question - Mailing list pgsql-novice

From chriswood@wvda.com
Subject subselect question
Date
Msg-id 3A34AB5C.13138.6147E1@localhost
Whole thread Raw
List 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
--------------------------------------------------------

pgsql-novice by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Re: [BUGS] 7.1beta1 JDBC Nested cursor problem
Next
From: "Mike Hammonds"
Date:
Subject: default password