From fc2e2ef64e58a852d6a9ab371e529465c32b2c5c Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Sun, 16 Nov 2003 20:29:34 +0000
Subject: Fix datetime input parsing to accept YYYY-MONTHNAME-DD and related
 syntaxes, which had been unintentionally broken by recent changes to tighten
 up the DateStyle rules for all-numeric date input.  Add documentation and
 regression tests for this, too.

---
 doc/src/sgml/datatype.sgml | 30 +++++++++++++++++++++++++++---
 1 file changed, 27 insertions(+), 3 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 26043b4fc29..676dcba1bbf 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.128.2.2 2003/11/06 22:21:55 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.128.2.3 2003/11/16 20:29:34 tgl Exp $
 -->
 
  <chapter id="datatype">
@@ -1464,7 +1464,7 @@ SELECT b, char_length(b) FROM test2;
         </row>
         <row>
          <entry>1999-01-08</entry>
-         <entry>ISO 8601, January 8 in any mode
+         <entry>ISO 8601; January 8 in any mode
          (recommended format)</entry>
         </row>
         <row>
@@ -1484,6 +1484,30 @@ SELECT b, char_length(b) FROM test2;
           February 3, 2001 in <literal>YMD</> mode
          </entry>
         </row>
+        <row>
+         <entry>1999-Jan-08</entry>
+         <entry>January 8 in any mode</entry>
+        </row>
+        <row>
+         <entry>Jan-08-1999</entry>
+         <entry>January 8 in any mode</entry>
+        </row>
+        <row>
+         <entry>08-Jan-1999</entry>
+         <entry>January 8 in any mode</entry>
+        </row>
+        <row>
+         <entry>99-Jan-08</entry>
+         <entry>January 8 in <literal>YMD</> mode, else error</entry>
+        </row>
+        <row>
+         <entry>08-Jan-99</entry>
+         <entry>January 8, except error in <literal>YMD</> mode</entry>
+        </row>
+        <row>
+         <entry>Jan-08-99</entry>
+         <entry>January 8, except error in <literal>YMD</> mode</entry>
+        </row>
         <row>
          <entry>19990108</entry>
          <entry>ISO 8601; January 8, 1999 in any mode</entry>
@@ -1625,7 +1649,7 @@ SELECT b, char_length(b) FROM test2;
          </row>
          <row>
           <entry><literal>zulu</literal></entry>
-          <entry>Military abbreviation for GMT</entry>
+          <entry>Military abbreviation for UTC</entry>
          </row>
          <row>
           <entry><literal>z</literal></entry>
-- 
cgit v1.2.3