| From: | Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com> |
|---|---|
| To: | "lists(at)kambanaria(dot)org" <lists(at)kambanaria(dot)org> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Function to spell out a number |
| Date: | 2010-11-04 16:11:19 |
| Message-ID: | 4CD2DB27.3090206@vmsinfo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
lists(at)kambanaria(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2010-11-04 16:53:59 | Re: Function to spell out a number |
| Previous Message | lists | 2010-11-04 14:28:46 | Function to spell out a number |