Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h3tXA-00013B-AL for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Mar 2019 02:22:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h3tX8-0004KL-QD for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Mar 2019 02:22:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h3tX8-0004KE-Et for pgsql-hackers@lists.postgresql.org; Wed, 13 Mar 2019 02:22:18 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h3tX5-0002D1-On for pgsql-hackers@lists.postgresql.org; Wed, 13 Mar 2019 02:22:17 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id E34DE22A0B; Tue, 12 Mar 2019 22:22:14 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Tue, 12 Mar 2019 22:22:14 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=FTsbI7jBWv8PhvvMSAz8Znlv5ov svLFfgDyuUQ8H0UM=; b=ByugDbpvbzm3eXTMQN+ipPR4RKInQO3z3gwcTRyzYso EByB2HnIEWb+ZO5OgO1y2ZjxUZDVBKBykBzlUCud35HVL1dUm6ktWM+RYRMWUo6d NEDWiAj3R1bJOKPKwJojG1SIevQ5cVkofUkXPxumz1/ySwz4s0jLJ7el1BGlAq1d hH0Uq/dut9qG6GuB85l41nArZh65Kfxp+2/9dj8AlyWar+rgY6957J1gStOEZNWM gQAokCPxb0Zgfusj9nEHRhKtjPzvBYiIhvI+O4NulRjX5sdNhZeqsgF/2KYioUTw rcnNvLYqxpZYm9E1I2MJDH+9MS9FFae7JIC14Vd6f2g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=FTsbI7 jBWv8PhvvMSAz8Znlv5ovsvLFfgDyuUQ8H0UM=; b=BFbjeOS21Lqq/KUdvBD/0x mWQi8TV0uY0VMAWiqRinALVrnmr2dgLw6aFeTQNa5tdzdWE4WciHSLgPhbNxPIri wG2VDCUbxY5u8TdRP3Xq8AP3FVtmC12CXDmk+0p2d7T4ZCdUFVKnEzZNk7OgJtRa 4ZHWpzWDLUTjA7cmnJGzQCFqJxb2jOwkWCLWv5EBCAMYRfx1hyM4NBo6A4FO2wy6 ZrLar2S8cBGWQ9UTtdnlYHYpt4at7cC81InHrpC/9z+HhGnx52XyhsU+NMTJkgGl hV43XQ2AcGdcUmlQveY+ZnCuGp6v6Eqm6LjHwnQtjfbw0ATcpkY02+YO6ewxgFww == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedutddrgeelgdeghecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdefhedmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfk phepiedurddvudehrddufeejrdduiedvnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmih gthhgrvghlsehprghquhhivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 71F9810336; Tue, 12 Mar 2019 22:22:12 -0400 (EDT) Date: Wed, 13 Mar 2019 11:21:59 +0900 From: Michael Paquier To: Tom Lane Cc: Postgres hackers Subject: Re: pgsql: Add support for hyperbolic functions, as well as log10(). Message-ID: <20190313022159.GR13812@paquier.xyz> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="juwRYO7N74otsfNI" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --juwRYO7N74otsfNI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Mar 12, 2019 at 07:55:14PM +0000, Tom Lane wrote: > Add support for hyperbolic functions, as well as log10(). >=20 > The SQL:2016 standard adds support for the hyperbolic functions > sinh(), cosh(), and tanh(). POSIX has long required libm to > provide those functions as well as their inverses asinh(), > acosh(), atanh(). Hence, let's just expose the libm functions > to the SQL level. As with the trig functions, we only implement > versions for float8, not numeric. jacana is not a fan of this commit, and failed on float8: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Djacana&dt=3D2019-= 03-13%2000%3A00%3A27 @@ -476,7 +476,7 @@ SELECT asinh(float8 '0'); asinh ------- - 0 + -0 (1 row) -- Michael --juwRYO7N74otsfNI Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlyIaUcACgkQnvQgOdby QH2//A//b6yntig8oftJwxpaTlEXNbYqUkBVU1VPlse6O9LtCxVdtcYqHgnikW8t 39zfoo0NbavqJ1GRt7zSrfafYFKLM2RJSAaFlOy7TUoDrbwgy1ABu4y51pOVygv3 aa+Vh2og77dt2MpKuV4UVxCE9sbvTtmXVUUQrVDZvFo4qCmpse2SOOR/T5HSqp0k 4bgkNlYC2VtzgkJ5IEwtSm8lSL0zzEdqumOQeHYVBUBvwMmbB0Du/yt2KKL8KSOM OhdAhwiYG1m9oHw6tRHINCZvJfHUFY+S9pChWLTtH8z0YgW2vPZmD9oKxENhU7+C l9EhXUoWOxRmnGg18vfrRnUty8yw/8RSEYzptrXKnxagnQSs2HaJtWxlYj68+IwT Z6vPv/kWiLmJGsIGPskQWaoXyBgqW/9NLYxzwwxYRzbBClW66FyNq5GNTvOqyPqd hYNlwhz7AjqdXEyFX1xUrT9jxi7sb2slsnIg2o6R249TZYOZHc+qnZTJAj1lAc04 FHVNvFkmn5sNXqaVj1nsNEx3/epO//rbmRHWhJdmwxVuAA9CNgRZJrudxtWabWNt T08Q1VMj3esE07sF1FV/fzrO8/kWOgxlXH9PUz6GekMEzNf6syF+WlTrJLIPEQvn H1VZrOMDo04NMwkuG4U54Eacg9pIAKHfbJSC0dDa1DwmgBsuYog= =PZuR -----END PGP SIGNATURE----- --juwRYO7N74otsfNI--