[GENERAL] CAST(integer_field AS character) truncates trailing zeros

[Warren Bell]

I am trying to cast an int to a character. The int is the number 1000 it 
gets cast down to "1" and not "1000". How do I cast from int to 
character without loosing the trailing zeros?

--
Thanks,
Warren Bell


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general