On tis, 2010-12-07 at 11:46 +0900, Itagaki Takahiro wrote:
> On Sun, Dec 5, 2010 at 01:04, Peter Eisentraut <peter_e@gmx.net> wrote:
> > Here is an updated patch to address the issues discussed during this
> > commitfest.
>
> I found another issue in the patch; ILIKE in WHERE clause doesn't work.
> It was surprising because LIKE in WHERE clause and ILIKE in SELECT list
> works expectedly.
> - SELECT * FROM pg_class WHERE relname LIKE 'pg%'
> - SELECT relname ILIKE 'pg%' FROM pg_class;
>
> ----
> postgres=# SELECT name, setting FROM pg_settings
> WHERE name IN ('lc_ctype', 'lc_collate', 'server_encoding');
> name | setting
> -----------------+---------
> lc_collate | C
> lc_ctype | C
> server_encoding | UTF8
> (3 rows)
>
> postgres=# SELECT * FROM pg_class WHERE relname ILIKE 'pg%';
> ERROR: no collation was derived
This is fixed in the 20101213 patch I'm about to send out.