Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tn9HN-0000EN-0Z for pgsql-docs@arkaria.postgresql.org; Mon, 24 Dec 2012 14:45:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tn9HM-0007KE-1n for pgsql-docs@arkaria.postgresql.org; Mon, 24 Dec 2012 14:45:20 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tn9HL-0007K8-Ad for pgsql-docs@postgresql.org; Mon, 24 Dec 2012 14:45:19 +0000 Received: from mout.gmx.net ([212.227.15.19]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tn9HH-0003Fo-PD for pgsql-docs@postgresql.org; Mon, 24 Dec 2012 14:45:18 +0000 Received: from mailout-de.gmx.net ([10.1.76.30]) by mrigmx.server.lan (mrigmx001) with ESMTP (Nemesis) id 0MfTEr-1TPiIj2KGx-00P4Gr for ; Mon, 24 Dec 2012 15:45:14 +0100 Received: (qmail invoked by alias); 24 Dec 2012 14:45:07 -0000 Received: from pool-108-52-108-60.phlapa.fios.verizon.net (EHLO [192.168.1.10]) [108.52.108.60] by mail.gmx.net (mp030) with SMTP; 24 Dec 2012 15:45:07 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX19auG1ILt9aOJ2c7+QAGyq+H6xB+XJD/ldNNu1Ly7 oWaR30Mw5wDc+0 Message-ID: <1356360300.5854.2.camel@vanquo.pezone.net> Subject: pattern matching indexing From: Peter Eisentraut To: pgsql-docs@postgresql.org Date: Mon, 24 Dec 2012 09:45:00 -0500 Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.4.4-1 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org To index pattern matching, you can use the _pattern_ops operator classes, or you can set the column collation in the index to "C". The latter option doesn't appear to be documented (unless you read very deep between the lines). Is that intentional? Also, there is no link from http://www.postgresql.org/docs/devel/static/functions-matching.html to either option. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs