diff options
| author | Daniel Gustafsson <dgustafsson@postgresql.org> | 2022-08-17 09:56:02 +0200 |
|---|---|---|
| committer | Daniel Gustafsson <dgustafsson@postgresql.org> | 2022-08-17 09:56:02 +0200 |
| commit | 3e7d94fca0e5ad8835b0f2b1a584c83ea11ce439 (patch) | |
| tree | cbddd351be962b2739d63b52f88fb45fc225cef3 | |
| parent | d265cd202961c240a2875826ca47822b54f74db5 (diff) | |
| download | postgresql-3e7d94fca0e5ad8835b0f2b1a584c83ea11ce439.tar.gz postgresql-3e7d94fca0e5ad8835b0f2b1a584c83ea11ce439.zip | |
doc: Document pg_trgm being case-insensitive by default
pg_trgm is by default operating case-insensitively but the docs didn't
mention that at all.
Author: Erik Rijkers <er@xs4all.nl>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: Daniel Gustafsson <daniel@yesql.se>
Reported-by: marcmaiwald@googlemail.com
Discussion: https://postgr.es/m/166064504415.652.12724576876807446945@wrigleys.postgresql.org
| -rw-r--r-- | doc/src/sgml/pgtrgm.sgml | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/doc/src/sgml/pgtrgm.sgml b/doc/src/sgml/pgtrgm.sgml index 7e292822553..fefe30afb7c 100644 --- a/doc/src/sgml/pgtrgm.sgml +++ b/doc/src/sgml/pgtrgm.sgml @@ -416,6 +416,8 @@ the above-described similarity operators, and additionally support trigram-based index searches for <literal>LIKE</literal>, <literal>ILIKE</literal>, <literal>~</literal>, <literal>~*</literal> and <literal>=</literal> queries. + The similarity comparisons are case-insensitive in a default build of + <filename>pg_trgm</filename>. Inequality operators are not supported. Note that those indexes may not be as efficient as regular B-tree indexes for equality operator. |