Re: [BUGS] numerics lose scale and precision in views of unions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [BUGS] numerics lose scale and precision in views of unions
Date
Msg-id 14349.1155217090@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] numerics lose scale and precision in views of unions  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
> This was using just a straight-up 'numeric' data type though.  Perhaps
> for that case we could drop the unnecessary zeros?

That would make numeric useless for the common scientific/engineering
usage where you write the number of decimal places you think are
significant in your measurement.  In that usage, "1.0" and "1.000"
do have different meanings.
        regards, tom lane


pgsql-hackers by date:

Previous
From: mark@mark.mielke.cc
Date:
Subject: Re: [BUGS] numerics lose scale and precision in views of unions
Next
From: José Orlando Pereira
Date:
Subject: Re: standard interfaces for replication providers