On Wed, Nov 02, 2005 at 08:48:25AM +0000, Simon Riggs wrote: > On Tue, 2005-11-01 at 18:15 -0500, Tom Lane wrote: > > Simon Riggs <[EMAIL PROTECTED]> 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.
Is it worth comming up with some script that users can run against a table to provide us with real data? -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
