On Wed, Feb 12, 2014 at 10:08:26PM +0900, MauMau wrote: > From: "Bruce Momjian" <br...@momjian.us> > >On Mon, Dec 2, 2013 at 10:22:47PM +0900, MauMau wrote: > >>So, my suggestion is to just add the following sentence right after > >>the above one. > >> > >>The Postgres style is an exception: the output of the date type is > >>either MM-DD-YYYY (e.g. 12-17-1997) or DD-MM-YYYY (e.g. 17-12-1997), > >>which is different from the date part of the output of the timestamp > >>type. > >> > >>Could you consider and add this to the manual? > > > >Yes, I will make the change unless someone objects. > > Could you commit this if you feel okay? I'm sorry if I missed the > modified article in the devel doc.
OK, attached doc patch applied to head and 9.3. Thanks for the report. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml new file mode 100644 index b7d7d80..30fd9bb *** a/doc/src/sgml/datatype.sgml --- b/doc/src/sgml/datatype.sgml *************** January 8 04:05:06 1999 PST *** 2205,2212 **** historical accident.) <xref linkend="datatype-datetime-output-table"> shows examples of each output style. The output of the <type>date</type> and ! <type>time</type> types is of course only the date or time part ! in accordance with the given examples. </para> <table id="datatype-datetime-output-table"> --- 2205,2214 ---- historical accident.) <xref linkend="datatype-datetime-output-table"> shows examples of each output style. The output of the <type>date</type> and ! <type>time</type> types is generally only the date or time part ! in accordance with the given examples. However, the ! <productname>POSTGRES</> style outputs date-only values in ! <acronym>ISO</acronym> format. </para> <table id="datatype-datetime-output-table">
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers