On Wed, 5 May 2004, scott.marlowe wrote:
> Just try this simple test in MySQL and see if the boss still thinks it's
> suitable for accounting:
I'll toss in the Pg version
db => create table test (i1 int, n1 numeric(8,2));
CREATE
db=> insert into test values (10000000000000,100000000000.345678);
ERROR: dtoi4: integer out of range
Oh my gosh ... an error! Oh yeah it is an error. :-)
Rod
--
"Open Source Software - You usually get more than you pay for..."
"Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"
