Re: [BUGS] numerics lose scale and precision in views of unions

Stephen Frost <sfrost@snowman.net> writes:
> Makes me curious if it really makes sense to keep trailing zeros...

AFAIR we consider them mainly as a display artifact.  An application
that's declared a column as numeric(7,2) is likely to expect to see
exactly two digits after the decimal point.

> Either 1.0 and 1.00 are
> the same thing (and thus should be displayed the same way), or they
> aren't (in which case they should be treated distinctly in, eg, a
> 'select distinct' clause).

Consistency has never been SQL's strong point ;-)
        regards, tom lane