thnx for your help albe.
i went through this code its working fine .
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-convert-numbers-into-words-in-postgresql-tp5755370p578.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent
Jashaswee wrote:
> i want to convert numbers into words in postgresql.is there any query for it?
> if yes please reply soon
I found two solutions in the Wiki:
http://wiki.postgresql.org/wiki/Integer_to_Text
http://wiki.postgresql.org/wiki/Numeric_to_English
Yours,
Laurenz Albe
--
Sent via pgsq
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Jashaswee asked:
> i want to convert numbers into words in postgresql.
> is there any query for it?
Easy enough with PlPerl:
$ sudo apt-get install liblingua-en-inflect-perl
$ createlang plperlu
$ psql < create or replace function numwords(i
On 05/14/2013 03:27 PM, Merlin Moncure wrote:
On Tue, May 14, 2013 at 5:24 PM, Adrian Klaver wrote:
Seems to only work with money type.
from the source:
/* cash_words()
* This converts a int4 as well but to a representation using words
* Obviously way North American centric - sorry
*/
On 15/05/13 08:27, Merlin Moncure wrote:
> On Tue, May 14, 2013 at 5:24 PM, Adrian Klaver
> wrote:
>> On 05/14/2013 03:17 PM, John R Pierce wrote:
>>>
>>> On 5/14/2013 2:57 PM, Alvaro Herrera wrote:
Jashaswee escribió:
>
>> i want to convert numbers into words in postgresql.is t
John R Pierce wrote:
> not sure I'd call that documentation. I was asking, where is that
> described in the postgresql manual? I looked in every category I
> thought was appropriate here,
> http://www.postgresql.org/docs/current/static/functions.html and
> didn't find it.
A quick grep in doc/s
On 5/14/2013 3:24 PM, Adrian Klaver wrote:
um, where is that documented? I've searched the various 'functions'
pages, and not seen it, nor is it in the manual Index.
production=> \df cash_words
List of functions
Schema |Name| Result data type | Argu
On Tue, May 14, 2013 at 5:24 PM, Adrian Klaver wrote:
> On 05/14/2013 03:17 PM, John R Pierce wrote:
>>
>> On 5/14/2013 2:57 PM, Alvaro Herrera wrote:
>>>
>>> Jashaswee escribió:
>i want to convert numbers into words in postgresql.is there any
query for it?
>if yes please reply
On Tue, May 14, 2013 at 4:32 PM, John R Pierce wrote:
> On 5/13/2013 11:27 PM, Jashaswee wrote:
>>
>> i want to convert numbers into words in postgresql.is there any query for
>> it?
>> if yes please reply soon
>
>
> you mean, like 123 -> "one hundred twenty three" ?that would be better
> don
On 05/14/2013 03:17 PM, John R Pierce wrote:
On 5/14/2013 2:57 PM, Alvaro Herrera wrote:
Jashaswee escribió:
>i want to convert numbers into words in postgresql.is there any
query for it?
>if yes please reply soon
Try cash_words()
um, where is that documented? I've searched the various 'fu
On 5/14/2013 2:57 PM, Alvaro Herrera wrote:
Jashaswee escribió:
>i want to convert numbers into words in postgresql.is there any query for it?
>if yes please reply soon
Try cash_words()
um, where is that documented? I've searched the various 'functions'
pages, and not seen it, nor is it in
Jashaswee escribió:
> i want to convert numbers into words in postgresql.is there any query for it?
> if yes please reply soon
Try cash_words()
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mail
On 5/13/2013 11:27 PM, Jashaswee wrote:
i want to convert numbers into words in postgresql.is there any query for it?
if yes please reply soon
you mean, like 123 -> "one hundred twenty three" ?that would be
better done in your client software.
--
john r pierce
On 14/05/2013 07:27, Jashaswee wrote:
> i want to convert numbers into words in postgresql.is there any query
> for it? if yes please reply soon
What exactly are you trying to do?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-genera
i want to convert numbers into words in postgresql.is there any query for it?
if yes please reply soon
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-convert-numbers-into-words-in-postgresql-tp5755370.html
Sent from the PostgreSQL - general mailing list archive
15 matches
Mail list logo
