From: | Lennin Caro <lennin(dot)caro(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, Warren Bell <warren(at)clarksnutrition(dot)com> |
Subject: | Re: CAST(integer_field AS character) truncates trailing zeros |
Date: | 2008-07-31 20:42:00 |
Message-ID: | 288260.83042.qm@web59510.mail.ac4.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--- On Thu, 7/31/08, Warren Bell <warren(at)clarksnutrition(dot)com> wrote:
> From: Warren Bell <warren(at)clarksnutrition(dot)com>
> Subject: [GENERAL] CAST(integer_field AS character) truncates trailing zeros
> To: pgsql-general(at)postgresql(dot)org
> Date: Thursday, July 31, 2008, 8:03 PM
> 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
>
>
work to me
template1=# select cast('1000' as varchar);
varchar
---------
1000
(1 fila)
template1=#
> --
> Sent via pgsql-general mailing list
> (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Douglas McNaught | 2008-07-31 20:44:04 | Re: CAST(integer_field AS character) truncates trailing zeros |
Previous Message | Robert Treat | 2008-07-31 20:17:46 | Re: Using PostGres general distribution |