On Mon, 2005-10-03 at 16:36 -0300, Giovanni M. wrote:
Yes! That did it, thanks for the help
On 10/3/05, Tony Wasson [EMAIL PROTECTED] wrote:
On 10/3/05, Giovanni M. [EMAIL PROTECTED] wrote:
Round and trunc dont provide the functionality I need.
Say for example I have two values in a
Hi guys,
I am searching for a function that enables me to strip the trailing
zeros in the fractional part of a number (numeric type). For example a
number saved in a column of type numeric as such: 23.45000 would be
returned as 23.45
I can't find any function that does this in the documentation,
Did you look at the round function?
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Giovanni M.
Sent: Monday, October 03, 2005 11:45 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] strip zeros from fractional part
Hi guys
Round and trunc dont provide the functionality I need.
Say for example I have two values in a column of type numeric as follows:
23.455
12.300
What I need to happen is stripping the useless zeros in the
fractional part of numbers so 12.300 would become 12.3 and 23.455
would stay the same
Round
On 10/3/05, Giovanni M. [EMAIL PROTECTED] wrote:
Round and trunc dont provide the functionality I need.
Say for example I have two values in a column of type numeric as follows:
23.455
12.300
What I need to happen is stripping the useless zeros in the
fractional part of numbers so 12.300
Yes! That did it, thanks for the help
On 10/3/05, Tony Wasson [EMAIL PROTECTED] wrote:
On 10/3/05, Giovanni M. [EMAIL PROTECTED] wrote:
Round and trunc dont provide the functionality I need.
Say for example I have two values in a column of type numeric as follows:
23.455
12.300