On Mon, Apr 13, 2009 at 2:40 PM, Tino Wildenhain <tino@xxxxxxxxxxxxx> wrote: > justin wrote: >> >> >> Tom Lane wrote: >>> >>> Tino Wildenhain <tino@xxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
