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(at)momjian(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +