Re: How to convert numbers into words in postgresql

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 '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 | Argument data types | Type
------------+------------+------------------+---------------------+--------
pg_catalog | cash_words | text | money | normal

Seems to only work with money type.

>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com