Re: Weird type selection choice

Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.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/