summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2016-02-21 15:23:17 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2016-02-21 15:23:17 -0500
commit64a169d1313d6b99b48c2d270df121ef43c03269 (patch)
treed2243dbde07e6554f3430052ba23b31f88613255
parentc7a1c5a6b6aa4bbc2c9619edc94368fccc1c8c8e (diff)
Docs: make prose discussion match the ordering of Table 9-58.
The "Session Information Functions" table seems to be sorted mostly alphabetically (although it's not perfect), which would be all right if it didn't lead to some related functions being described in a pretty nonintuitive order. Also, the prose discussions after the table were in an order that hardly matched the table at all. Rearrange to make things a bit easier to follow.
-rw-r--r--doc/src/sgml/func.sgml72
1 files changed, 36 insertions, 36 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 60f117a3333..b001ce548d8 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -15003,6 +15003,12 @@ SELECT * FROM pg_ls_dir('.') WITH ORDINALITY AS t(ls,n);
</row>
<row>
+ <entry><literal><function>pg_my_temp_schema()</function></literal></entry>
+ <entry><type>oid</type></entry>
+ <entry>OID of session's temporary schema, or 0 if none</entry>
+ </row>
+
+ <row>
<entry><literal><function>pg_is_other_temp_schema(<type>oid</type>)</function></literal></entry>
<entry><type>boolean</type></entry>
<entry>is schema another session's temporary schema?</entry>
@@ -15021,12 +15027,6 @@ SELECT * FROM pg_ls_dir('.') WITH ORDINALITY AS t(ls,n);
</row>
<row>
- <entry><literal><function>pg_my_temp_schema()</function></literal></entry>
- <entry><type>oid</type></entry>
- <entry>OID of session's temporary schema, or 0 if none</entry>
- </row>
-
- <row>
<entry><literal><function>pg_postmaster_start_time()</function></literal></entry>
<entry><type>timestamp with time zone</type></entry>
<entry>server start time</entry>
@@ -15157,25 +15157,6 @@ SET search_path TO <replaceable>schema</> <optional>, <replaceable>schema</>, ..
</note>
<indexterm>
- <primary>pg_listening_channels</primary>
- </indexterm>
-
- <indexterm>
- <primary>pg_notification_queue_usage</primary>
- </indexterm>
-
- <para>
- <function>pg_listening_channels</function> returns a set of names of
- asynchronous notification channels that the current session is listening
- to. <function>pg_notification_queue_usage</function> returns the
- fraction of the total available space for notifications currently
- occupied by notifications that are waiting to be processed, as a
- <type>double</type> in the range 0-1.
- See <xref linkend="sql-listen"> and <xref linkend="sql-notify">
- for more information.
- </para>
-
- <indexterm>
<primary>inet_client_addr</primary>
</indexterm>
@@ -15203,6 +15184,20 @@ SET search_path TO <replaceable>schema</> <optional>, <replaceable>schema</>, ..
</para>
<indexterm>
+ <primary>pg_conf_load_time</primary>
+ </indexterm>
+
+ <para>
+ <function>pg_conf_load_time</function> returns the
+ <type>timestamp with time zone</type> when the
+ server configuration files were last loaded.
+ (If the current session was alive at the time, this will be the time
+ when the session itself re-read the configuration files, so the
+ reading will vary a little in different sessions. Otherwise it is
+ the time when the postmaster process re-read the configuration files.)
+ </para>
+
+ <indexterm>
<primary>pg_my_temp_schema</primary>
</indexterm>
@@ -15221,27 +15216,32 @@ SET search_path TO <replaceable>schema</> <optional>, <replaceable>schema</>, ..
</para>
<indexterm>
- <primary>pg_postmaster_start_time</primary>
+ <primary>pg_listening_channels</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>pg_notification_queue_usage</primary>
</indexterm>
<para>
- <function>pg_postmaster_start_time</function> returns the
- <type>timestamp with time zone</type> when the
- server started.
+ <function>pg_listening_channels</function> returns a set of names of
+ asynchronous notification channels that the current session is listening
+ to. <function>pg_notification_queue_usage</function> returns the
+ fraction of the total available space for notifications currently
+ occupied by notifications that are waiting to be processed, as a
+ <type>double</type> in the range 0-1.
+ See <xref linkend="sql-listen"> and <xref linkend="sql-notify">
+ for more information.
</para>
<indexterm>
- <primary>pg_conf_load_time</primary>
+ <primary>pg_postmaster_start_time</primary>
</indexterm>
<para>
- <function>pg_conf_load_time</function> returns the
+ <function>pg_postmaster_start_time</function> returns the
<type>timestamp with time zone</type> when the
- server configuration files were last loaded.
- (If the current session was alive at the time, this will be the time
- when the session itself re-read the configuration files, so the
- reading will vary a little in different sessions. Otherwise it is
- the time when the postmaster process re-read the configuration files.)
+ server started.
</para>
<indexterm>