pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Erik Wienhold <ewie@ewie.name>
Subject: [PATCH v1] Add note about missing money operators
Date: Mon, 18 Mar 2024 19:38:53 +0100

---
 doc/src/sgml/datatype.sgml | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 73e51b0b11..d4b4ec54bc 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1118,6 +1118,16 @@ SELECT '52093.89'::money::numeric::float8;
     value, the result is <type>double precision</type> (i.e., a pure number,
     not money); the currency units cancel each other out in the division.
    </para>
+
+   <note>
+    <para>
+     <type>Money</type> does not implement all
+     <link linkend="functions-math-op-table">operators</link>
+     that one might expect of a numeric type.  For example, use
+     <literal>(-amount::numeric)::money</literal> to negate
+     <literal>amount</literal>.
+    </para>
+   </note>
   </sect1>
 
 
-- 
2.44.0


--riyccdku42erpwog--





Message-ID: <no-message-id-9660@localhost>
Permalink:  ../no-message-id-9660@localhost/
Also on:    postgresql.org/message-id/no-message-id-9660@localhost

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: ewie@ewie.name
  Subject: Re: [PATCH v1] Add note about missing money operators
  In-Reply-To: <no-message-id-9660@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox