I guess it would help if I cast to the correct type. I was doing cast( cast( 1000 as integer ) as char ) instead of character varying, char(n) or text.

Thanks,

Warren



Warren Bell wrote:
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
909-645-8864
[EMAIL PROTECTED]


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

Reply via email to