Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: CAST(integer_field AS character) truncates trailing zeros
- From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
- To: "Warren Bell" <warren(at)clarksnutrition(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: CAST(integer_field AS character) truncates trailing zeros
- Date: Thu, 31 Jul 2008 16:16:33 -0400
- Message-id: <5ded07e00807311316n5e8753ap7bdc44e5f965b02a@mail.gmail.com> <text/plain>
On Thu, Jul 31, 2008 at 4: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? Please supply the exact syntax that you're using to do the cast. -Doug
- References:
- CAST(integer_field AS character) truncates trailing zeros
- From: Warren Bell
- CAST(integer_field AS character) truncates trailing zeros
- Prev by Date: CAST(integer_field AS character) truncates trailing zeros
- Next by Date: Re: CAST(integer_field AS character) truncates trailing zeros
- Previous by thread: CAST(integer_field AS character) truncates trailing zeros
- Next by thread: Re: CAST(integer_field AS character) truncates trailing zeros
- Indexes: