Re: [GENERAL] Monetary, Float Types - Mailing list pgsql-general

From darcy@druid.net (D'Arcy J.M. Cain)
Subject Re: [GENERAL] Monetary, Float Types
Date
Msg-id m0zh1tC-0000eRC@druid.net
Whole thread Raw
In response to Monetary, Float Types  (Rob Cleveland <rob.cleveland@wardsauto.com>)
List pgsql-general
Thus spake Rob Cleveland
> I am trying to add prices together using either the monetary type or =
> float4 type.  Monetary doesn't seem to add, and float4 renders results =

darcy=> select '12.34'::money + '43.21'::money;
?column?
--------
$55.55
(1 row)

Can  you show an example that doesn't work?

--
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.

pgsql-general by date:

Previous
From: "Gilley, Charles H."
Date:
Subject: FW: [GENERAL] Loading a database, ...
Next
From: Peter T Mount
Date:
Subject: Re: [GENERAL] Re: Large Objects