postgres.git / summary / log / commit / refs

commit    f0c437cf548bf80bc2bd203a745f379052a1bda9
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Thu Jun 03 03:04:55 2010 +0000
First released in: 9.0.0

    Document that citext operators must be in the current search path.


 doc/src/sgml/citext.sgml | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

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>
 


[parent: 356e4dbf9afb]