Home > mailing lists

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

From	Warren Bell
Subject	CAST(integer_field AS character) truncates trailing zeros
Date	July 31, 2008 20:11:49
Msg-id	48921A75.4090608@clarksnutrition.com Whole thread Raw
Responses	Re: CAST(integer_field AS character) truncates trailing zeros Re: CAST(integer_field AS character) truncates trailing zeros Re: CAST(integer_field AS character) truncates trailing zeros Re: CAST(integer_field AS character) truncates trailing zeros
List	pgsql-general

Tree view

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

pgsql-general by date:

From: David R Robison
Date: 31 July 2008, 19:46:30
Subject: Re: Doing an LDAP lookup from a SQL SELECT

From: "Douglas McNaught"
Date: 31 July 2008, 20:16:38
Subject: Re: CAST(integer_field AS character) truncates trailing zeros

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

Previous

Next