Re: CAST(integer_field AS character) truncates trailing zeros

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