Re: Converting number to words

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Robert Fitzpatrick <robert(at)webtent(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Converting number to words
Date: 2004-11-06 05:46:04
Message-ID: 200411060546.iA65k4d29466@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera wrote:
> On Fri, Nov 05, 2004 at 05:18:01PM -0500, Robert Fitzpatrick wrote:
> > I searched through the net quickly and the list archives, but could not
> > find anything doing this. Is it possible? There is a Perl module for
> > doing this, but I guess cannot use modules for security reasons.
>
> But you can use plperlu to define a function to do that.

cash_words() will convert an int4.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexey Borzov 2004-11-06 08:14:33 Re: [GENERAL] Gborg down?
Previous Message Neil Conway 2004-11-06 04:59:21 Re: Using EXECUTE in same manner as SELECT