Re: floating point representationu - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: floating point representationu
Date
Msg-id 3A91DADE.9F0E5415@tpf.co.jp
Whole thread Raw
In response to Re: floating point representationu  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: floating point representationu  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian wrote:
> 
> >
> > Tom Lane wrote:
> > >
> > > Peter Eisentraut <peter_e@gmx.net> writes:
> > > > Actually, you're going to have to recode the float*in() functions, using
> > > > scanf, and scanf's formats are not always equivalent to printf's.
> > >
> > > Further thought: one answer to this is to institute four SET variables,
> > > two for output and two for input; perhaps FLOAT8_FORMAT, FLOAT8_IN_FORMAT,
> > > and similarly for FLOAT4.  The input formats would normally just be
> > > "%lg" and "%g" but could be changed for special cases (like reading
> > > table dumps prepared with %a output format).
> > >
> >
> > >From the first I don't want to change the current default
> > output format
> >       "%." #FLT_DIG "g" (REAL)
> >       "%." #DBL_DIG "g" (DOUBLE PRECISION)
> > for 7.1 because their changes would cause a regress
> > test failure.
> 
> But we run regress with the proper setting, right?> How does giving
> people the ability to change the defaults affect the regression tests?
> 

Hmm I'm afraid I'm misunderstanding your point.
If the default float4(8) output format would be the
same as current output format then we would have no
problem with the current regress test. But there
could be a choise to change default output format
to have a large enough presision to distinguish
float4(8).

Regards,
Hiroshi Inoue


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] Turkish locale bug
Next
From: Larry Rosenman
Date:
Subject: Re: Re: [BUGS] Turkish locale bug