AFAICT, ILIKE cannot use an index. So why does ILIKE even exist, when lower(expr) LIKE 'foo' provides a solution that can use an index and is more standard, too? -- Peter Eisentraut peter_e@gmx.net
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных