On Sat, 24 Nov 2007 11:27:38 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> 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. > And second, why are there no regression tests for MONEY. I see it used > only once in the rules test. I think that scrappy added this into the code before we were so vigorous about creating regression tests for everything. I agree that there should be something. I personally unit test all my own code and I am a big test booster. I will look at adding something in. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
