Re: CAST(integer_field AS character) truncates trailing zeros

On Thu, Jul 31, 2008 at 4:17 PM, Richard Broersma
<richard.broersma@gmail.com> wrote:
> On Thu, Jul 31, 2008 at 1:03 PM, Warren Bell <warren@clarksnutrition.com> 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