to_char() Question

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: PG-General General <pgsql-general(at)postgresql(dot)org>
Subject: to_char() Question
Date: 2005-12-13 16:05:11
Message-ID: 200512131105.11235.terry@esc1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2005-12-13 16:06:13 Re: Bug#342369: PostgreSQL 8.1.0 RHEL / Debian incompatible
Previous Message Wes 2005-12-13 16:04:47 Re: Excessive vacuum times