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