[Note: Cc list trimmed as everyone is probably on the list anyway]

On Tue, 9 Oct 2007 09:02:09 -0700
"Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> However, keep in mind that I really don't care if Money is deprecated
> or not. I do care that the docs say it is, and it may not be. :)

Understood.  Personally I would like to see that comment dropped but it
isn't my decision.  I did fix the biggest complaints in the recent
change to 64 bit storage so perhaps someone can see their way clear to
dropping that comment.  Here is a suggested change.

Index: datatype.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v
retrieving revision 1.209
diff -u -p -u -r1.209 datatype.sgml
--- datatype.sgml       31 Aug 2007 04:52:29 -0000      1.209
+++ datatype.sgml       9 Oct 2007 16:30:13 -0000
@@ -828,14 +828,6 @@ ALTER SEQUENCE <replaceable class="param
   <sect1 id="datatype-money">
    <title>Monetary Types</title>

-   <note>
-    <para>
-     The <type>money</type> type is deprecated. Use
-     <type>numeric</type> or <type>decimal</type> instead, in
-     combination with the <function>to_char</function> function.
-    </para>
-   </note>
-
    <para>
     The <type>money</type> type stores a currency amount with a fixed
     fractional precision; see <xref
@@ -846,6 +838,15 @@ ALTER SEQUENCE <replaceable class="param
     Output is generally in the latter form but depends on the locale.
    </para>

+   <para>
+    Due to locale changes this type may have problems with dump and
+    restore and care should be taken.  Also, I/O is slower than using
+    NUMERIC or DECIMAL but internal calculations such as SUM will be
+    faster due to its internal storage format.  Be sure to weigh all
+    these considerations as well as convenience when choosing between
+    this type and others.
+   </para>
+
     <table id="datatype-money-table">
      <title>Monetary Types</title>
      <tgroup cols="4">

-- 
D'Arcy J.M. Cain <[EMAIL PROTECTED]>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to