right align (justify) to_char outcome in a column

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: right align (justify) to_char outcome in a column
Date: 2005-09-27 20:04:35
Message-ID: 20050927200434.GA9201@deby.ei.hnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

after reading the manual ("Data Type Formatting Functios") and googling
quite a bit I couldn't find an answer to the subject question.

I'm wondering if it's at all possible to right align a column (being the
product of 2 numerical cols) - formatted to_char
(....,'FM999,999,999.00') in a select.
Leaving values as they are (numerical) and using the
(...,'FM999,999,999.00') format template will display the result without
the group separator ...

Thanks for your attention.
Regards,
Ennio.

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]

Browse pgsql-novice by date

  From Date Subject
Next Message shadowbox 2005-09-28 11:59:53 stored procedure problem: parameters not properly passed
Previous Message A Gilmore 2005-09-27 17:54:45 Re: View