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: | [email protected] |
Views: | Whole Thread | Raw Message | 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.
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! |