Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > It apparently casts the 1 to double precision to pick the variant
> > trunc(dp)=>dp instead of trunc(numeric)=>numeric. I was under the
> > impression that we didn't want to cast integers to float types
> > implicitly because this loses information. Clearly, the numeric
> > variant should be preferred anyway.
>
> There's nothing "clear" about that at all.
The clarity stems from the fact that this is the variant that doesn't
lose data whereas the other one does.
The expression I originally posted works on Oracle. I wonder how they
do it.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/