Skip site navigation (1)
Skip section navigation (2)
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?
Peripheral Links
Header And Logo
|
Site Navigation
CAST(integer_field AS character) truncates trailing zeros
- From: Warren Bell <warren(at)clarksnutrition(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: CAST(integer_field AS character) truncates trailing zeros
- Date: Thu, 31 Jul 2008 13:03:01 -0700
- Message-id: <48921A75.4090608@clarksnutrition.com> <text/plain>
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
- Follow-Ups:
- Re: CAST(integer_field AS character) truncates trailing zeros
- From: Warren Bell
- Re: CAST(integer_field AS character) truncates trailing zeros
- From: Lennin Caro
- Re: CAST(integer_field AS character) truncates trailing zeros
- From: Richard Broersma
- Re: CAST(integer_field AS character) truncates trailing zeros
- From: Douglas McNaught
- Re: CAST(integer_field AS character) truncates trailing zeros
- Prev by Date: Re: Doing an LDAP lookup from a SQL SELECT
- Next by Date: Re: CAST(integer_field AS character) truncates trailing zeros
- Previous by thread: Using PostGres general distribution
- Next by thread: Re: CAST(integer_field AS character) truncates trailing zeros
- Indexes: