Re: [PATCHES] Fixes for MONEY type using locale

Bruce Momjian wrote:
> D'Arcy J.M. Cain wrote:
> > On Sat, 24 Nov 2007 11:27:38 -0500 (EST)
> > Bruce Momjian <bruce@momjian.us> wrote:
> > > I am confused about two other items with MONEY.  First, why can't
> > > anything but a string be cast to this type?
> > > 
> > >     test=> select 871234872319489323::money;
> > >     ERROR:  cannot cast type bigint to money
> > >     LINE 1: select 871234872319489323::money;
> > >                                        ^
> > >     test=> select 871234872::money;
> > >     ERROR:  cannot cast type integer to money
> > >     LINE 1: select 871234872::money;
> > >                               ^
> > >     test=> select 87123487231.3::money;
> > >     ERROR:  cannot cast type numeric to money
> > >     LINE 1: select 87123487231.3::money;
> > >                                   ^
> > 
> > I agree.  I wasn't the one that added the meta information.
> 
> OK, so the big question then is if we are un-depricating this data type,
> does it have the behavior we want?  (And the regression addition will be
> helpful too.)

Added to TODO list:
       * Allow MONEY to be cast to/from other numeric data types

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +