From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Per-column collation |
Date: | 2010-12-12 22:12:40 |
Message-ID: | 1292191960.15408.8.camel@vanquo.pezone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On tis, 2010-12-07 at 11:46 +0900, Itagaki Takahiro wrote:
> On Sun, Dec 5, 2010 at 01:04, Peter Eisentraut <peter_e(at)gmx(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2010-12-12 22:13:40 | Re: Per-column collation |
Previous Message | Peter Eisentraut | 2010-12-12 22:04:11 | Re: create tablespace fails silently, or succeeds improperly |