From: | Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Per-column collation |
Date: | 2010-12-07 02:46:24 |
Message-ID: | AANLkTimkGt4LDRGZBqy9cv5VRBOssgsEYOCBzWsQ=PV8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
----
--
Itagaki Takahiro
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2010-12-07 02:48:55 | Re: profiling connection overhead |
Previous Message | Fujii Masao | 2010-12-07 02:37:25 | Re: wal_sender_delay is still required? |