Re: Rounding Float Array

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Rounding Float Array
Date: 2015-09-21 10:27:17
Message-ID: 20150921102717.GA19873@tux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hubert depesz lubaczewski <depesz(at)depesz(dot)com> wrote:

> > Is there an easy way to round all values to 4 decimals.
>
> Sure:
>
> (depesz(at)[local]:5960) 12:15:46 [depesz]
> $ select geoloc::numeric(8,4)[] from alex;
> geoloc
> -------------------
> {5.3443,100.2946}

Nice!

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Mair 2015-09-21 10:29:34 Re: Rounding Float Array
Previous Message hubert depesz lubaczewski 2015-09-21 10:16:27 Re: Rounding Float Array