On Thu, Jul 31, 2008 at 4:17 PM, Richard Broersma <[EMAIL PROTECTED]> wrote: > 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)
AFAIK, CHAR means CHAR(1), so there are not enough characters to contain the result and it gets truncated. Maybe TEXT should be used instead, or VARCHAR? -Doug -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general