Re: Per-column collation

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.