On 2002-01-03 "Aasmund Midttun Godal" <postgresql(at)envisity(dot)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