Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TnSp1-0001sS-LK for pgsql-admin@arkaria.postgresql.org; Tue, 25 Dec 2012 11:37:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TnSp1-0000I6-6A for pgsql-admin@arkaria.postgresql.org; Tue, 25 Dec 2012 11:37:23 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TnSp0-0000I1-FJ for pgsql-admin@postgresql.org; Tue, 25 Dec 2012 11:37:22 +0000 Received: from blu0-omc1-s15.blu0.hotmail.com ([65.55.116.26]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TnSoy-0003iy-OJ for pgsql-admin@postgresql.org; Tue, 25 Dec 2012 11:37:21 +0000 Received: from BLU0-SMTP295 ([65.55.116.7]) by blu0-omc1-s15.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Tue, 25 Dec 2012 03:37:18 -0800 X-EIP: [CYmJuBpeN6/QMZfPjtcrxdd/qtqL5zEe] X-Originating-Email: [liuhaifeng@live.com] Message-ID: Received: from [172.16.227.13] ([61.170.250.85]) by BLU0-SMTP295.blu0.hotmail.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.4675); Tue, 25 Dec 2012 03:37:17 -0800 From: Haifeng Liu Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Does index based on text with 'en_US.utf8' collation support like query? Date: Tue, 25 Dec 2012 19:37:10 +0800 To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 (Mac OS X Mail 6.2 \(1499\)) X-Mailer: Apple Mail (2.1499) X-OriginalArrivalTime: 25 Dec 2012 11:37:17.0572 (UTC) FILETIME=[316A9C40:01CDE294] X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi, I found that queries like "select * from tbl where col1 like 'abc%'" will u= se index only when the col1(and the index) use 'C' collation. If I use 'def= ault' which is 'en_US.utf8' in my database, the equation condition will use= the index but like query will not. I also tried to specify the collation explicitly: like ('abc%' collate 'en_= US.utf8'), not work too. Is that only 'C' collation support 'like' query or I missed something in my= sql? Or do I need to install something additional to support index on othe= r collation? Thanks in advance. --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin