Request a Demo
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 [email protected]
Whole thread Raw
In response to CAST(integer_field AS character) truncates trailing zeros  (Warren Bell <[email protected]>)
List pgsql-general
Tree view 
On Thu, Jul 31, 2008 at 4:03 PM, Warren Bell <[email protected]> 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