Postgres Pro
Downloads
Home   >   mailing lists

Re: CAST(integer_field AS character) truncates trailing zeros - Mailing list pgsql-general

From Douglas McNaught
Subject Re: CAST(integer_field AS character) truncates trailing zeros
Date
Msg-id 5ded07e00807311316n5e8753ap7bdc44e5f965b02a@mail.gmail.com
Whole thread Raw
In response to CAST(integer_field AS character) truncates trailing zeros  (Warren Bell <warren@clarksnutrition.com>)
List pgsql-general
Tree view 
On Thu, Jul 31, 2008 at 4:03 PM, Warren Bell <warren@clarksnutrition.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

pgsql-general by date:

Previous
From: Warren Bell
Date:
Subject: CAST(integer_field AS character) truncates trailing zeros
Next
From: "Richard Broersma"
Date:
Subject: Re: CAST(integer_field AS character) truncates trailing zeros