Re: to_char adds leading space, intended?

On 2002-01-03 "Aasmund Midttun Godal" <postgresql@envisity.com> wrote:
>envisity=# SELECT '''' || to_char(1234, '099999') || '''';

> ?column?
>-----------
> ' 001234'
>(1 row)

Modifier "FM" in the format string is your friend    SELECT '''' || to_char(1234, 'FM099999') || '''';
                ^^
 

Table 4.11 on    http://www.postgresql.org/idocs/index.php?functions-formatting.html
--
AXXESSIT ASA                  http://www.axxessit.no
Rolf Østvik / Test technician
Phone : (+47) 69 17 38 19     Fax: (+47) 69 17 39 00
P.O. Box 1053, Isebakkevn. 25, N-1787 Berg i Østfold