Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend