Unanswered: best way to convert numbers to words in a table
I'm using php and a postgresql 7.4 database. I have a table that has one field for storing numbers(such as 34.23) that represent dollar amounts. I then have another field field that I'd like to have the equivalent dollar amount but written out in words. For example:
34.23 thirty-four dollars and twenty-three cents
Does anyone know how I can do this with some sort of update query or something?