Date: Thu, 5 Jan 2017 11:23:31 -0500
From: Bruce Momjian <bruce@momjian.us>
To: loren.szendre@gmail.com
Cc: pgsql-docs@postgresql.org
Subject: Re: case-insensitive index lower()
Message-ID: <20170105162331.GA3265@momjian.us>
References: <20161220100242.25618.66302@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20161220100242.25618.66302@wrigleys.postgresql.org>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

On Tue, Dec 20, 2016 at 10:02:42AM +0000, loren.szendre@gmail.com wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/9.1/static/sql-createindex.html
> Description:
> 
> In the section on indexes the documentation accurately describes how to
> create an efficient, case-insensitive index using lower(field_name). But! in
> Firebird to get a query to utilize such index, you must write the query as
> such:
> 
> WHERE myfield = lower(:myfield)
> 
> Otherwise a table scan is performed. The documentation should state whether
> or not such a thing is required. It&#39;s one thing to create an index, it&#39;s
> quite another to know how to write a statement that guarantees that the
> index will be used.

I don't see that as useful for the majority of people reading the
documentation.  EXPLAIN will clearly show the index being used.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs