diff options
| author | Bruce Momjian <bruce@momjian.us> | 2010-06-03 03:04:55 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2010-06-03 03:04:55 +0000 |
| commit | f0c437cf548bf80bc2bd203a745f379052a1bda9 (patch) | |
| tree | 9749a35bfbe04b01f9ed153cb3c2db79830f0f73 | |
| parent | 356e4dbf9afbcdd61a35581c5bb43404d75fc305 (diff) | |
| download | postgresql-f0c437cf548bf80bc2bd203a745f379052a1bda9.tar.gz postgresql-f0c437cf548bf80bc2bd203a745f379052a1bda9.zip | |
Document that citext operators must be in the current search path.
| -rw-r--r-- | doc/src/sgml/citext.sgml | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/doc/src/sgml/citext.sgml b/doc/src/sgml/citext.sgml index 43ebd259586..bfef39d7446 100644 --- a/doc/src/sgml/citext.sgml +++ b/doc/src/sgml/citext.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/citext.sgml,v 1.2 2008/09/12 18:29:49 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/citext.sgml,v 1.3 2010/06/03 03:04:55 momjian Exp $ --> <sect1 id="citext"> <title>citext</title> @@ -205,6 +205,15 @@ will need two indexes if you want both types of searches to be fast. </para> </listitem> + + <listitem> + <para> + The schema containing the <type>citext</> operators must be + in the current <varname>search_path</> (typically <literal>public</>); + if it is not, a normal case-sensitive <type>text</> comparison + is performed. + </para> + </listitem> </itemizedlist> </sect2> |