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.klaver@gmail.com