From 70007b4dd5e91cc0ea7590b66b38cdf8d2143b15 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Mon, 19 Feb 2007 18:20:06 +0000
Subject: [PATCH] Clarify documentation for "day of the week" handling for
 to_char() and EXTRACT().

---
 doc/src/sgml/func.sgml | 19 +++++++++++--------
 1 file changed, 11 insertions(+), 8 deletions(-)

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index ac7a0d1638..1b336ba65d 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.362 2007/02/19 17:41:38 momjian Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.363 2007/02/19 18:20:06 momjian Exp $ -->
 
  <chapter id="functions">
   <title>Functions and Operators</title>
@@ -4617,11 +4617,11 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})');
        </row>
        <row>
         <entry><literal>D</literal></entry>
-        <entry>day of week (1-7; Sunday is 1)</entry>
+        <entry>day of the week, Sunday(<literal>1</>) to Saturday(<literal>7</>)</entry>
        </row>
        <row>
         <entry><literal>ID</literal></entry>
-        <entry>ISO day of week (1-7; Monday is 1)</entry>
+        <entry>ISO day of the week, Monday(<literal>1</>) to Sunday(<literal>7</>)</entry>
        </row>
        <row>
         <entry><literal>W</literal></entry>
@@ -4844,9 +4844,11 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})');
      </listitem>
 
      <listitem>
-      <para><function>to_char</function>'s day of the week numbering
-        (see the 'D' formatting pattern) is different from that of the 
-        <function>extract</function> function.
+      <para>
+        <function>to_char(..., 'ID')</function>'s day of the week numbering
+        matches the <function>extract('isodow', ...)</function> function.
+        <function>to_char(..., 'D')</function>'s does not match
+        <function>extract('dow', ...)</function>'s day numbering.
       </para>
      </listitem>
 
@@ -5741,8 +5743,9 @@ SELECT EXTRACT(DOW FROM TIMESTAMP '2001-02-16 20:38:40');
 <lineannotation>Result: </lineannotation><computeroutput>5</computeroutput>
 </screen>
        <para>
-        Note that <function>extract</function>'s day of the week numbering is
-        different from that of the <function>to_char</function> function.
+        Note that <function>extract</function>'s day of the week numbering
+        is different from that of the <function>to_char(...,
+        'D')</function> function.
        </para>
 
       </listitem>
-- 
2.40.0