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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
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
On Thu, Jul 31, 2008 at 1: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?
Here is what I get when I try:
postgres=#
--- On Thu, 7/31/08, Warren Bell [EMAIL PROTECTED] wrote:
From: Warren Bell [EMAIL PROTECTED]
Subject: [GENERAL] CAST(integer_field AS character) truncates trailing zeros
To: pgsql-general@postgresql.org
Date: Thursday, July 31, 2008, 8:03 PM
I am trying to cast an int to a character
On Thu, Jul 31, 2008 at 4:17 PM, Richard Broersma
[EMAIL PROTECTED] wrote:
On Thu, Jul 31, 2008 at 1: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
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