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 hav
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
> >
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
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
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 fract
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,
