Re: Number Conversion Function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tino Wildenhain <tino(at)living-examples(dot)com>
Cc: Abdul Rehman <abr_ora(at)yahoo(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Number Conversion Function
Date: 2009-04-06 14:11:39
Message-ID: 27615.1239027099@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tino Wildenhain <tino(at)living-examples(dot)com> writes:
> Abdul Rehman wrote:
>> Can any body help me in converting numeric values into words via
>> postgres function: i.e. 313 to THREE HUNDRED THREE

> I would not recommend to do this within the database. Thats typical
> a job for your presentation layer.

... but having said that, I think the "money" datatype has a function
for this. Whether that's of any use to you I dunno; money is pretty
restrictive about what it can handle.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2009-04-06 14:13:47 Re: Postgres Security Checklist
Previous Message Tom Lane 2009-04-06 14:00:24 Re: Postgres Security Checklist