Re: CAST(integer_field AS character) truncates trailing zeros

["Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>]

On Thu, Jul 31, 2008 at 1:03 PM, Warren Bell <warren(at)clarksnutrition(dot)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)

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