Re: Case insensitive

Поиск
Список
Период
Сортировка
От Oliver Elphick
Тема Re: Case insensitive
Дата
Msg-id 1028995146.31339.175.camel@linda
обсуждение исходный текст
Ответ на Case insensitive  ("Carmen Wai" <wai_carmen@hotmail.com>)
Список pgsql-general
Дерево обсуждения 
On Sat, 2002-08-10 at 16:22, Carmen Wai wrote:
> Hi:
>
> Do anyone have any idea to configure the postgresql so that it can perform
> case-insensitive matching automatically? [other than--select * from table
> where lower(col_value) = lower(pattern)]

You can use ILIKE  (WHERE col ILIKE 'pattern')

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "If ye abide in me, and my words abide in you, ye shall
      ask what ye will, and it shall be done unto you."
                                      John 15:7

В списке pgsql-general по дате отправления: