Could we use DOMAIN to make MONEY an alias for NUMERIC, perhaps using
locale to make it customized, somehow?
---
Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > we need someone to get MONEY working as an extented NUME
Tom you are correct here (like usual), sorry for the wasted thread and time
regarding functions that I remembered being there but infact were not.
On Wednesday 29 January 2003 10:56, Tom Lane wrote:
> Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> > Sorry my mistake on versions.
> > darcy=> SEL
Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> Sorry my mistake on versions.
> darcy=> SELECT '1.0'::MONEY::FLOAT;
> ?column?
>
>1
> (1 row)
> darcy=> select version();
> version
> ---
Sorry my mistake on versions.
darcy=> SELECT '1.0'::MONEY::FLOAT;
?column?
1
(1 row)
darcy=> SELECT '1.0'::MONEY::TEXT;
?column?
1.0
(1 row)
darcy=> select version();
version
-
Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> In 7.1 and prior I could do a SELECT '1.0'::MONEY::TEXT or to NUMERIC
> or to FLOAT even.
No, you couldn't.
regression=# SELECT '1.0'::MONEY::TEXT ;
ERROR: Cannot cast type 'money' to 'text'
regression=# select version();
The problem here is not that we are getting rid of MONEY as datatype, (I see
no need for it with having numeric) the problem comes from haveing no way to
migrate MONEY to NUMERIC short of hand editing the pgdump file and then
reimporting. Yes I know I can use sed, but that is not the point. I
On Tue, Jan 28, 2003 at 08:24:13PM +0100, Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > we need someone to get MONEY working as an extented NUMERIC type.
>
> How would the new "money" be different from "numeric"? If we have
> "money", should we have "length", "mass", and "temperature"?
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> How would the new "money" be different from "numeric"?
[ temporarily re-dons currency-trader hat... ]
What would actually be useful is a money type that carries along an
indication of which currency the amount is expressed in (not per-column
as Bruce
Bruce Momjian writes:
> we need someone to get MONEY working as an extented NUMERIC type.
How would the new "money" be different from "numeric"? If we have
"money", should we have "length", "mass", and "temperature"? I think not.
Just let the money type die and that's it.
--
Peter Eisentraut
Bruce,
> They are probably better off just changing the column data type, _and_
> we need someone to get MONEY working as an extented NUMERIC type.
Apparently D'Arcy McCain is going to do this. Go, D'arcy!
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(
They are probably better off just changing the column data type, _and_
we need someone to get MONEY working as an extented NUMERIC type.
---
Josh Berkus wrote:
> Folks,
>
> Bug reported off IRC:
>
> MONEY Type cannot be ca
Folks,
Bug reported off IRC:
MONEY Type cannot be cast to any other type, preventing migration from this
depreciated data type.
Affects: 7.2.3, 7.3.1
Frequency: 100% Reproducable
Effect When Occurring: Unable to convert, query data
Difficulty of Fix: Easy, probably
Certianty of Diagnosis:
12 matches
Mail list logo
