On 10/26/12 11:50, Samuel Gilbert wrote: > > (SELECT to_char(42, '000000000') AS string) AS example; > > string | length | showthemtome > ------------+--------+-------------- > 000000042 | 10 | " 000000042" Sign padding. Try using: select to_char(42, 'FM000000000') ... To see why, look here: http://www.postgresql.org/docs/9.2/static/functions-formatting.html#FUNCTIONS-FORMATTING-NUMERICMOD-TABLE HTH Bosco.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных