subselect question

Поиск
Список
Период
Сортировка
От chriswood@wvda.com
Тема subselect question
Дата
Msg-id 3A34AB5C.13138.6147E1@localhost
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: Re: [BUGS] 7.1beta1 JDBC Nested cursor problem
Следующее
От: "Mike Hammonds"
Дата:
Сообщение: default password