Patch applied. Thanks. ---------------------------------------------------------------------------
David Fetter wrote: > On Thu, Sep 28, 2006 at 11:16:56PM +0200, Martijn van Oosterhout wrote: > > On Thu, Sep 28, 2006 at 05:11:43PM -0400, Tom Lane wrote: > > > David Fetter <[EMAIL PROTECTED]> writes: > > > > ! DETAIL: A field with precision 4, scale 4 must have an absolute > > > > value less than 1. > > > > [ becomes ] > > > > ! DETAIL: A field with precision 4, scale 4 must have an absolute > > > > value less than 1 - 5 * 10^-5. > > > > > > This strikes me as overly pedantic. The message needs to be clear, > > > and the proposed change will just confuse people. > > > > I don't know if the code can detect the difference, but a message like: > > > > A field with precision 4, scale 4 must *round to* an absolute value less > > than 1 > > > > Since that more accurately describes the actual problem. > > > > Have a ncie day, > > Per your suggestion, how about this patch? > > Cheers, > D > -- > David Fetter <[EMAIL PROTECTED]> http://fetter.org/ > phone: +1 415 235 3778 AIM: dfetter666 > Skype: davidfetter > > Remember to vote! [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings