Skip site navigation (1)
Skip section navigation (2)
I guess it would help if I cast to the correct type. I was doing cast( cast( 1000 as integer ) as char ) instead of character varying, char(n) or text.
Peripheral Links
Header And Logo
|
Site Navigation
Re: CAST(integer_field AS character) truncates trailing zeros
- From: Warren Bell <warren(at)clarksnutrition(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: CAST(integer_field AS character) truncates trailing zeros
- Date: Thu, 31 Jul 2008 14:05:58 -0700
- Message-id: <48922936.5070400@clarksnutrition.com> <text/plain>
I guess it would help if I cast to the correct type. I was doing cast( cast( 1000 as integer ) as char ) instead of character varying, char(n) or text.
Thanks, Warren Warren Bell 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?
-- Thanks, Warren Bell 909-645-8864 warren(at)clarksnutrition(dot)com
- References:
- CAST(integer_field AS character) truncates trailing zeros
- From: Warren Bell
- CAST(integer_field AS character) truncates trailing zeros
- Prev by Date: Re: CAST(integer_field AS character) truncates trailing zeros
- Next by Date: Re: Using PostGres general distribution
- Previous by thread: Re: CAST(integer_field AS character) truncates trailing zeros
- Next by thread: eliminating records not in (select id ... so SLOW?
- Indexes: