On Tue, Mar 15, 2016 at 12:02 PM, Francisco Olarte wrote:
> 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.