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. Good advice. Thank you, F rancisco Frank |