Re: [PATCHES] Fixes for MONEY type using locale

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.)

--  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. +