Re: [Patch] Log10 and hyperbolic functions for SQL:2016 compliance

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Lætitia Avrot <laetitia(dot)avrot(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [Patch] Log10 and hyperbolic functions for SQL:2016 compliance
Date: 2019-02-11 20:29:48
Message-ID: 9e5e0b16-315c-1bea-20d8-e8aadd63bd54@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 12/02/2019 06:44, Lætitia Avrot wrote:
> Hi Andrew and Tom,
>
> I considered that option before writing my patch but I refrained for 2
> reasons:
>
> - There is no consensus about how to name these functions. The
> standard 8000-2 goes with arsinh, arcosh and artanh,
>   but you will find easily arcsinh, arccosh and arctanh or even
> argsinh, argcosh and argtanh. In IT, the names asinh,
>   acosh and atanh are commonly used too. We might implement them with
> asinh, acosh and atanh names and add
>   aliases if SQL standard decide to add it under other names though.
[...]
>
> Le dim. 3 févr. 2019 à 16:12, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
> <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>> a écrit :
>
> Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk
> <mailto:andrew(at)tao11(dot)riddles(dot)org(dot)uk>> writes:
> > The spec doesn't require the inverse functions (asinh, acosh,
> atanh),
> > but surely there is no principled reason to omit them?
>
> +1 --- AFAICS, the C library has offered all six since C89.
>
>                         regards, tom lane
>
[...]

I can only remember coming across the asinh, acosh, and atanh forms.  In
45 years of programming.

Cheers,
Gavin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-02-11 20:38:47 Re: [Patch] Log10 and hyperbolic functions for SQL:2016 compliance
Previous Message Alvaro Herrera 2019-02-11 20:04:45 Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages)