Not sure if there is a numeric formatting option that allows what you want.
But how about?
substr(to_char(1029, '9,999'),2)
John
Terry Lee Tucker said:
> Greetings List:
>
> I am using to_char to format numeric data into a string that is ultimately
> displayed in an XmText widget. Much of the numeric data is always going to
> be
> positive. In some of the windows that display this data, space is at a
> premium. Basically, I need to display something like 1,029 in an XmText
> widget that is exactly 5 characters wide. In a select statement like:
> SELECT to_char (1029, '9,999'), to_char always puts one extra space in the
> leftmost position for a numeric sign. What I get is: ' 1,029', which
> causes
> me to have to have the XmText widget 6 characters wide as opposed to 5.
> This
> is becoming a problem on several of the application windows where, as I
> said
> earlier, space is at a premium. The only way that I've been able to
> suppress
> the extra space is by the following: SELECT to_char (1029, 'FM9,999').
> What I
> get then is a string that is not right justified and I want the numbers to
> be
> right justified. Now, finally, the question: Is there a way to suppress
> the
> extra space for the sign?
>
> TIA
> rnd=# select version();
> version
> --------------------------------------------------------------------------------------------------------------
> PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
> 3.2.3
> 20030502 (Red Hat Linux 3.2.3-49)
> (1 row)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
