> Looks like cash_words is fixed in current CVS, so I guess in 7.2.1: > > Welcome to psql 7.3devel, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help on internal slash commands > \g or terminate with semicolon to execute query > \q to quit > > test=> select cash_words('-700000000000000000000000000000'); > > cash_words > > > ------------------------------------------------------------------ > -------------------------------------------------- > > Minus twenty one million four hundred seventy four thousand eight > hundred thirty six dollars and forty eight cents > (1 row)
It doesn't crash - but it sure is giving the wrong answer ;) Chris ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html