| 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: | 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! |