From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it> |
Cc: | hackers postgres <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] money or dollar type |
Date: | 1998-05-12 13:38:39 |
Message-ID: | 355850DF.BC133F00@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Seems there's some problems with type 'money'... I can't multiply or
> divide 'money' types, and can't cast it properly to other data types.
> Is this a bug ?
With the new type conversion code:
tgl=> create table mm (m money);
CREATE
tgl=> insert into mm values ('$1600.00');
INSERT 268105 1
tgl=> select m * 1.1 from mm;
?column?
---------
$1,760.00
(1 row)
But,
tgl=> select cast(m as float8) from mm;
float8
----------
1077124288
(1 row)
So there is some funny interaction on the casting, the same as you found
in v6.3.2 (and presumably forever), which I will look into...
- Tom
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1998-05-12 14:30:53 | Re: [HACKERS] Re: [PATCHES] Try again: S_LOCK reduced contentionh] |
Previous Message | Thomas G. Lockhart | 1998-05-12 13:16:04 | Re: AW: [HACKERS] Re: [QUESTIONS] money or dollar type |