Re: Function to spell out a number

lists@kambanaria.org wrote:
> Hi everyone,
> I've checked the manual and a bit online but could not find this:
> Is there a provided function to spell out numbers in Postgres? (in
> different languages if possible.)
> For example:
> to_words(1234) => 'two hundred and thirty four"
> Kind regards:
> al_shopov
>
>
There is a Perl module Number::Spell which has that functionality. It
supports all important languages, both British English and the American
English. You can write a plperlu function and grant execute on it to the
application user.

--

Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions