Re: Number Conversion Function

On Mon, Apr 13, 2009 at 2:40 PM, Tino Wildenhain <tino(at)wildenhain(dot)de> wrote:
> justin wrote:
>>
>>
>> Tom Lane wrote:
>>>
>>> Tino Wildenhain <tino(at)living-examples(dot)com> writes:
>>>
>>>>
>>>> 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
>>>
>>
>> I disagree the database is the wrong place, there are cases it makes
>> sense.
>>
> Which cases would that be?

What if you had several different 'presentation layers' interfacing
with the database? Say, a internal web app, some reporting programs
used by sales, dept, the old delphi program that no one ever bothered
to rewrite, etc. Do you really want to implement the formatting
function in all those places?

as a general rule, the more i do in the database, the easier things
are for me in the long run.

merlin