Skip site navigation (1) Skip section navigation (2)

Re: Function to spell out a number

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 (view raw or flat)
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




In response to

pgsql-novice by date

Next:From: Thomas KellererDate: 2010-11-04 16:53:59
Subject: Re: Function to spell out a number
Previous:From: listsDate: 2010-11-04 14:28:46
Subject: Function to spell out a number

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group