Search Postgresql Archives

Re: numeric precision when raising one numeric to

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, 2005-05-20 at 11:16, Stephan Szabo wrote:
> On Fri, 20 May 2005, Scott Marlowe wrote:

> 
> > 2:  How many people who DO work with large exponents and need arbitrary
> > precision have looked at postgresql, typed in "select 3^100" got back
> > 5.15377520732011e+47, and simply went to another piece of software and
> > never looked back?  We don't know.  And the attitude that it seems
> > useless to me so it must be useless to everybody else isn't going to
> > help attract people who do things that seem esoteric and strange to you,
> > but are important to them.
> 
> As a note, I don't think it's useless.  I simply think the argument that
> anything that can be included should is invalid.  I could make
> equivalent arguments for a whole lot of things and that's when the cost
> argument starts making more sense.

Agreed.  However, I think that if PostgreSQL has support for numerics of
1000 characters, it might make sense for it to have the operators to
ensure that operations exist for most if not all common mathmatical
operations, especially since many esoteric math functions could make use
of such accuracy.  

I wonder what Joe Conway's take on all this would be, since he's the guy
that made PL/R a reality.  

I don't think we should include anything that could be added either.  U
just don't like surprises, which is what I consider it when I raise one
numeric to another numeric and get a floating point answer.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux