Re: Unexpected result using floor() function

> Hi Frank:
>

> This may byte you any day, so I wuld recommend doing
>
> s=> select v, pg_typeof(v) from (select floor(4.725 * power(cast(10 as
> numeric), 2) + 0.5)) as aux(v);
>   v  | pg_typeof
> -----+-----------
>  473 | numeric
> (1 row)
>
> which makes your intention clear.

Good advice. Thank you, F

rancisco

 

Frank