#265 Add support for hyperbolic functions

open
nobody
engine (144)
5
2011-05-07
2011-05-07
Lukas Eder
No

Many RDBMS support hyperbolic functions. While this is certainly not a high priority, it might be nice to support at least these three:

SINH
COSH
TANH

They're available in java.lang.Math, as documented also in
http://hsqldb.org/doc/2.0/guide/sqlroutines-chapt.html#N12EC6

Discussion

  • Fred Toussi
    Fred Toussi
    2011-11-25

    We might add them for completeness. But could you please find a Java Math function that is not normally covered by SQL dialects and we can use it as an excample in the Guide :)

     
  • Lukas Eder
    Lukas Eder
    2012-04-06

    Hi Fred,

    I must've missed this comment. Sure, these are some Java Math functions that are not covered:

    - CBRT (although that can be achieved with POWER, which again can be achieved with EXP and LN)
    - HYPOT (I haven't encountered that one yet...)
    - RINT
    - ULP

    This is a non-authoritative answer. Anyway, I don't think that many people had been missing these functions in SQL. :-)
    Maybe CBRT and HYPOT are useful to some...