case-insensitive index lower()

From: loren(dot)szendre(at)gmail(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: case-insensitive index lower()
Date: 2016-12-20 10:02:42
Message-ID: 20161220100242.25618.66302@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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's one thing to create an index, it's
quite another to know how to write a statement that guarantees that the
index will be used.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message vodevsh 2016-12-21 15:13:29 pg_class.reloptions for tables to mention Storage Parameters
Previous Message celia 2016-12-19 23:00:33 Use return type of TEXT rather than varchar[] is better for me!