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.