Re: case-(in)sensitive Server

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: case-(in)sensitive Server
Дата
Msg-id 29476.1024001322@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: case-(in)sensitive Server  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: case-(in)sensitive Server
Список pgsql-novice
Josh Berkus <josh@agliodbs.com> writes:
> He wants
> SELECT * FROM table_a WHERE code = 'volume';
> to be automagically replaced with:
> SELECT * FROM table_a WHRE code ILIKE 'volume';

I don't see any way we could do that at the server level without causing
*all* text = operations to work that way; which almost inevitably would
break something.

Given that the client-side code is open source, I would think that a
client-side solution would be no harder to make happen, and it'd surely
be a lot cleaner.

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: case-(in)sensitive Server
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: case-(in)sensitive Server