From eb1ad5b4b57e95c8755acccc0796b44072aba209 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Sat, 15 Jun 2002 20:03:51 +0000
Subject: Patch for current_schemas to optionally include implicit ...

Second cut attached. This one just adds a boolean option to the existing
function to indicate that implicit schemas are to be included (or not).
I remembered the docs as well this time :-)

Dave Page
---
 doc/src/sgml/func.sgml | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 976147f5c2a..4c30789eff4 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.102 2002/06/15 02:59:55 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.103 2002/06/15 20:03:51 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -4323,9 +4323,9 @@ SELECT NULLIF(value, '(none)') ...
        <entry>name of current schema</entry>
       </row>
       <row>
-       <entry><function>current_schemas()</function></entry>
+       <entry><function>current_schemas(boolean)</function></entry>
        <entry><type>name[]</type></entry>
-       <entry>names of schemas in search path</entry>
+       <entry>names of schemas in search path optionally including implicit schemas</entry>
       </row>
      </tbody>
     </tgroup>
@@ -4378,10 +4378,10 @@ SELECT NULLIF(value, '(none)') ...
     at the front of the search path (or NULL if the search path is
     empty).  This is the schema that will be used for any tables or
     other named objects that are created without specifying a target schema.
-    <function>current_schemas</function> returns an array of the names of all
-    schemas presently in the search path.  Note that these functions show
-    only schemas that are explicitly part of the path; when a system schema
-    is being searched implicitly, it is not listed.
+    <function>current_schemas(boolean)</function> returns an array of the names of all
+    schemas presently in the search path.  The boolean option determines whether or not
+    implicitly included system schemas such as pg_catalog are included in the search 
+    path returned.
    </para>
 
    <table>
-- 
cgit v1.2.3