From: | "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Do we need multiple forms of the SQL2003 statistics |
Date: | 2006-07-29 17:51:31 |
Message-ID: | Pine.LNX.4.64.0607292139120.26646@lnfm1.sai.msu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom, thank you for the reviewing/correcting/applying my patches...
On Fri, 28 Jul 2006, Tom Lane wrote:
> I wrote:
>> There is room to argue that the numeric-arithmetic version would be
>> worth having on the grounds of greater precision or range, but it's a
>> big chunk of code and the public demand for the functionality has not
>> exactly been overwhelming.
>
>> Comments?
>
> Since no one's even bothered to respond, I take it there's insufficient
> interest in the numeric versions of these aggregates. I've committed
> just the float8 versions.
My opinion on that is
1) I agree that really the float4 version are useless, because they don't
offer anything new... comparing to the float8
2) But I think the numeric versions of these functions are not useless...
(if somebody have numeric columns... )
I don't think the 10-15 additional functions in pg_proc is too much.
Concerning to the amount of code in numeric.c I think it is large, but not
complicated at all, so I don't think that it will be a problem to support
that code.
I think since we are supporting the numeric type as a special
high-precision type, Postgres must have the high-precision
versions of all computational functions. Just my opinion.
>
> I added some very trivial regression tests, which we'll have to keep an
> eye on to see if they have any portability problems. We may need to
> back off the number of displayed fraction digits to get them to pass
> everywhere.
>
> If anyone wants to do better tests, feel free...
I will try to write some better tests and send a patch.
Regards,
Sergey
*******************************************************************
Sergey E. Koposov
Max Planck Institute for Astronomy/Sternberg Astronomical Institute
Tel: +49-6221-528-349
Web: http://lnfm1.sai.msu.ru/~math
E-mail: math(at)sai(dot)msu(dot)ru
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2006-07-29 17:56:15 | Re: DTrace enabled build fails |
Previous Message | Bruce Momjian | 2006-07-29 17:45:47 | Re: CREATE INDEX ... ONLINE |