On Thu, Jul 31, 2008 at 1:03 PM, Warren Bell <[EMAIL PROTECTED]> 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?
Here is what I get when I try: postgres=# select cast( cast( 1000 as integer ) as char ); bpchar -------- 1 (1 row) postgres=# select cast( cast( 1000 as integer ) as char(10) ); bpchar ------------ 1000 (1 row) -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general