Re: [GENERAL] Monetary, Float Types

From: darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain)
To: rob(dot)cleveland(at)wardsauto(dot)com (Rob Cleveland)
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Monetary, Float Types
Date: 1998-11-21 01:31:06
Message-ID: m0zh1tC-0000eRC@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at){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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter T Mount 1998-11-21 12:32:51 Re: [GENERAL] Re: Large Objects
Previous Message Gilley, Charles H. 1998-11-20 23:33:24 FW: [GENERAL] Loading a database, ...