On Tue, 2005-11-01 at 18:15 -0500, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > Anybody like to work out a piece of SQL to perform data profiling and
> > derive the distribution of values with trailing zeroes?
>
> Don't forget leading zeroes. And all-zero (we omit digits entirely in
> that case). I don't think you can claim that zero isn't a common case.
The question is: how common?
For INTEGERs I would accept that many are often zero. For NUMERIC, these
are seldom exactly zero, IMHO.
This is one of those issues where we need to run tests and take input.
We cannot decide this sort of thing just by debate alone. So, I'll leave
this as a less potentially fruitful line of enquiry.
Best Regards, Simon Riggs