diff options
| -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> |