Re: Format an Update with calculation - Mailing list pgsql-general

From Ron
Subject Re: Format an Update with calculation
Date
Msg-id 87215601-3060-7966-2b85-53f2de2eb87f@gmail.com
Whole thread Raw
In response to Re: Format an Update with calculation  (Condor <condor@stz-bg.com>)
List pgsql-general
On 12/19/2018 02:12 AM, Condor wrote:
> On 18-12-2018 15:51, Adrian Klaver wrote:
[snip]
>> In addition to what Pavel posted:
>>
>> select round(43.2335, 2);
>>
>>  round
>> -------
>>  43.23
>
>
> Beware with round and numeric
>
> select round(43.2375, 2);
>  round
> -------
>  43.24
>
>
>  select 43.2375::numeric(17, 2);
>  numeric
> ---------
>    43.24

Beware of what?


-- 
Angular momentum makes the world go 'round.


pgsql-general by date:

Previous
From: "Arnaud L."
Date:
Subject: Re: How to compare dates from two tables with blanks values
Next
From: Oleksandr Shulgin
Date:
Subject: Re: Error on insert xml