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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: "Brian C(dot) DeRocher" <brian(dot)derocher(at)mitretek(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [BUGS] numerics lose scale and precision in views of unions
Date: 2006-08-10 13:38:10
Message-ID: 14349.1155217090@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Stephen Frost <sfrost(at)snowman(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message mark 2006-08-10 14:17:39 Re: [BUGS] numerics lose scale and precision in views of unions
Previous Message mark 2006-08-10 13:22:46 Re: [BUGS] numerics lose scale and precision in views of unions

Browse pgsql-hackers by date

  From Date Subject
Next Message José Orlando Pereira 2006-08-10 14:00:15 Re: standard interfaces for replication providers
Previous Message mark 2006-08-10 13:22:46 Re: [BUGS] numerics lose scale and precision in views of unions