Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lPnj5-0006nI-CF for pgsql-docs@arkaria.postgresql.org; Fri, 26 Mar 2021 14:46:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lPnj4-0000rr-BL for pgsql-docs@arkaria.postgresql.org; Fri, 26 Mar 2021 14:46:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lPnj4-0000ri-2b for pgsql-docs@lists.postgresql.org; Fri, 26 Mar 2021 14:46:14 +0000 Received: from mail-ej1-x632.google.com ([2a00:1450:4864:20::632]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lPnj1-0004oV-Ii for pgsql-docs@lists.postgresql.org; Fri, 26 Mar 2021 14:46:13 +0000 Received: by mail-ej1-x632.google.com with SMTP id r12so8806000ejr.5 for ; Fri, 26 Mar 2021 07:46:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dreamsolution.nl; s=google; h=to:from:subject:organization:message-id:date:user-agent :mime-version; bh=03qqngrF76b3v0dsLIylG4gJouTyfjRINYQugPTfP2s=; b=XtoeI+Gy6rxcZzBtRfgNrW/0WdNzLrG2H0ZNRLnq2TwktwABhfFezPPdgWA2tpczos 5gLL+YDVHfe84QRlhcKpfq/2eya4P74oYuv8AcQbGAMwGjnK25B8ss5zakrHMaj7hcNe BXCBKFvc/TdnzUPtW6ABoSS3J2I8/b7VhNBJCTmoCNxmMlWFhqs4b8Wm2rq68GJ574Oz 1Wp33u88VGxFx3frk3AVMu89Zv9za9MkUMGI4s7BnK4bdEmkopAZIVEHiAxNF65fJ/dp s3muxoH6sxE9IC4RzZxSchECcNwS7wML2O93OYVN7RD78vgr7V5WCIcf1clwYEVopnGN 1/mA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:organization:message-id:date :user-agent:mime-version; bh=03qqngrF76b3v0dsLIylG4gJouTyfjRINYQugPTfP2s=; b=KQTStQzLjPNeEBkn7Zsr8ZcQPruyy4QzESrUvizMCLpkt3ioS7xNqxk4CLSrwJquoH 81qeXDU/M7ZSKQp+RrzHgkiEg/pZlE01mE5ICUFL52AsS0ZAVhj5bldoHAeOQ7BsNe2j Cx8fwPm+84VQyGy+HCYCA7NYeopCXhehlyY23EjKm5W6FqzqKlW8mXWUoFT+XXf4cnzW Gl668h+3qkj0ZLC3UlWRgVFUYPT1iTujR0fM0nyW/i7wVGMciF50lGBmG5gmlpzazo2O FkFBkN6+sNCyzLI6/vshk9TqWEmpaK+dtHLpma4PkLJj1YLRVfExhVU54ErBwsnfqAas uvcA== X-Gm-Message-State: AOAM532wnUEyjd9hZdGHra4A1qGgL3+lx26K2jSg9nY/vwx+p0bRMO9l dA3uiqbiiDBZ2Ln0b7taiOMDpztnSLDIntbf X-Google-Smtp-Source: ABdhPJwpwteh8jwmgAKGzaibGSZ53FfT+he1CbJVtblkHpHgoEHfjVVgd9DQnFNgw1P67z/3rJoegw== X-Received: by 2002:a17:906:6d8e:: with SMTP id h14mr15796370ejt.410.1616769970308; Fri, 26 Mar 2021 07:46:10 -0700 (PDT) Received: from hondecoeter.d11n.nl (2001-1c00-0b0e-5600-7572-555d-d64e-cba6.cable.dynamic.v6.ziggo.nl. [2001:1c00:b0e:5600:7572:555d:d64e:cba6]) by smtp.gmail.com with ESMTPSA id g22sm3963832ejm.69.2021.03.26.07.46.09 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 26 Mar 2021 07:46:09 -0700 (PDT) To: pgsql-docs@lists.postgresql.org From: Rudolph Froger Subject: Rounding strategy of round function Organization: Dreamsolution BV Message-ID: Date: Fri, 26 Mar 2021 15:46:08 +0100 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:78.0) Gecko/20100101 Thunderbird/78.8.1 MIME-Version: 1.0 Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg=sha-512; boundary="------------ms040108040003070205070708" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a cryptographically signed message in MIME format. --------------ms040108040003070205070708 Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: quoted-printable The 'round' mathematical function doesn't document which rounding=20 strategy it uses. If this would be documented then users can rely on its = rounding behavior. For double precision the rounding probably depends on = your platform. For numeric is the function seems to round to nearest=20 with ties (a 5) going away from zero (sometimes referred to as "round=20 half up). 6.5 -> 7.0 and -6.5 -> -7.0. https://www.postgresql.org/docs/current/functions-math.html Kind regards, Rudolph --------------ms040108040003070205070708 Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExDzANBglghkgBZQMEAgMFADCABgkqhkiG9w0BBwEAAKCC DFswggYQMIID+KADAgECAhBNlCwQ1DvglAnFgS06KwZPMA0GCSqGSIb3DQEBDAUAMIGIMQsw CQYDVQQGEwJVUzETMBEGA1UECBMKTmV3IEplcnNleTEUMBIGA1UEBxMLSmVyc2V5IENpdHkx HjAcBgNVBAoTFVRoZSBVU0VSVFJVU1QgTmV0d29yazEuMCwGA1UEAxMlVVNFUlRydXN0IFJT QSBDZXJ0aWZpY2F0aW9uIEF1dGhvcml0eTAeFw0xODExMDIwMDAwMDBaFw0zMDEyMzEyMzU5 NTlaMIGWMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYD VQQHEwdTYWxmb3JkMRgwFgYDVQQKEw9TZWN0aWdvIExpbWl0ZWQxPjA8BgNVBAMTNVNlY3Rp Z28gUlNBIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBMIIBIjAN BgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAyjztlApB/975Rrno1jvm2pK/KxBOqhq8gr2+ JhwpKirSzZxQgT9tlC7zl6hn1fXjSo5MqXUfItMltrMaXqcESJuK8dtK56NCSrq4iDKaKq9N xOXFmqXX2zN8HHGjQ2b2Xv0v1L5Nk1MQPKA19xeWQcpGEGFUUd0kN+oHox+L9aV1rjfNiCj3 bJk6kJaOPabPi2503nn/ITX5e8WfPnGw4VuZ79Khj1YBrf24k5Ee1sLTHsLtpiK9OjG4iQRB dq6Z/TlVx/hGAez5h36bBJMxqdHLpdwIUkTqT8se3ed0PewDch/8kHPo5fZl5u1B0ecpq/sD N/5sCG52Ds+QU5O5EwIDAQABo4IBZDCCAWAwHwYDVR0jBBgwFoAUU3m/WqorSs9UgOHYm8Cd 8rIDZsswHQYDVR0OBBYEFAnA8vwL2pTbX/4r36iZQs/J4K0AMA4GA1UdDwEB/wQEAwIBhjAS BgNVHRMBAf8ECDAGAQH/AgEAMB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDARBgNV HSAECjAIMAYGBFUdIAAwUAYDVR0fBEkwRzBFoEOgQYY/aHR0cDovL2NybC51c2VydHJ1c3Qu Y29tL1VTRVJUcnVzdFJTQUNlcnRpZmljYXRpb25BdXRob3JpdHkuY3JsMHYGCCsGAQUFBwEB BGowaDA/BggrBgEFBQcwAoYzaHR0cDovL2NydC51c2VydHJ1c3QuY29tL1VTRVJUcnVzdFJT QUFkZFRydXN0Q0EuY3J0MCUGCCsGAQUFBzABhhlodHRwOi8vb2NzcC51c2VydHJ1c3QuY29t MA0GCSqGSIb3DQEBDAUAA4ICAQBBRHUAqznCFfXejpVtMnFojADdF9d6HBA4kMjjsb0XMZHz tuOCtKF+xswhh2GqkW5JQrM8zVlU+A2VP72Ky2nlRA1GwmIPgou74TZ/XTarHG8zdMSgaDrk VYzz1g3nIVO9IHk96VwsacIvBF8JfqIs+8aWH2PfSUrNxP6Ys7U0sZYx4rXD6+cqFq/ZW5BU fClN/rhk2ddQXyn7kkmka2RQb9d90nmNHdgKrwfQ49mQ2hWQNDkJJIXwKjYA6VUR/fZUFeCU isdDe/0ABLTI+jheXUV1eoYV7lNwNBKpeHdNuO6Aacb533JlfeUHxvBz9OfYWUiXu09sMAvi M11Q0DuMZ5760CdO2VnpsXP4KxaYIhvqPqUMWqRdWyn7crItNkZeroXaecG03i3mM7dkiPaC kgocBg0EBYsbZDZ8bsG3a08LwEsL1Ygz3SBsyECa0waq4hOf/Z85F2w2ZpXfP+w8q4ifwO90 SGZZV+HR/Jh6rEaVPDRF/CEGVqR1hiuQOZ1YL5ezMTX0ZSLwrymUE0pwi/KDaiYB15uswgeI AcA6JzPFf9pLkAFFWs1QNyN++niFhsM47qodx/PL+5jR87myx5uYdBEQkkDc+lKB1Wct6ucX qm2EmsaQ0M95QjTmy+rDWjkDYdw3Ms6mSWE3Bn7i5ZgtwCLXgAIe5W8mybM2JzCCBkMwggUr oAMCAQICEQCf+Zr+s8dn6Dz5UebnhvekMA0GCSqGSIb3DQEBCwUAMIGWMQswCQYDVQQGEwJH QjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRgwFgYD VQQKEw9TZWN0aWdvIExpbWl0ZWQxPjA8BgNVBAMTNVNlY3RpZ28gUlNBIENsaWVudCBBdXRo ZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBMB4XDTIxMDIxMDAwMDAwMFoXDTIzMDIx MDIzNTk1OVowSDEXMBUGA1UEAxMOUnVkb2xwaCBGcm9nZXIxLTArBgkqhkiG9w0BCQEWHnJ1 ZG9scGhmcm9nZXJAZHJlYW1zb2x1dGlvbi5ubDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCC AgoCggIBALTbaiIkQ1QAOTux9Ef9IHIpxS/Td+/4BEwXT4SgPCmQwYmF1ee4QX60k/jw9la3 hBRNtX418sGdrMubKh1DbDQb91HDawNy41erShb0LHvbkSqQ7siMecITcS7y9uhmGLNUvxQ4 xee9wA2PbSmmiuh8HQMv/vO1DpOUC50Fafd7EQkv9lUYM1vj313b7WKzlTEO8WxQNfH2lo4b jMV9I/dE21xp16bxJQ29u3SLVUjX9u5YfeGmienkJpmwekIUtjklvO/FDhXVV4MRFxVgph9N M9Yj/ZnJnxTxsNj44SMh/vvaKCkp0K+7NG47gdGCHZGCzp3m8uNxC1PfeYWs92lfQAHbO0B9 umhjowkfIixR8QwYyg+zEDxjQr/8OA+VjWg+kPOmsuJbZOykM+8R5MiyQDrPHdTCKXmhsbyX /yltNx0JHiI0Q7tbYnY+eYyCv14E1vwOzhiE0o+lewKfTkJmULOebVD7IWbSGbF3FG9vMNly 13/tPCsM4WTtPvMpkiopFy7uReo7W8lEv5RzT5lEH9KN+f56pE/PllcLhVJTKIDIhogjRuQn oNxkbgykBMCMXsWBrfnQn3VXfqasa5stT/OgglqVoan6EfkMkhYRkhQA3jTfvPDXbGyYtGyR LbJLqE5SJDiPv8UC12HfCPpQjhItoHWBDII7u5CLHyutAgMBAAGjggHXMIIB0zAfBgNVHSME GDAWgBQJwPL8C9qU21/+K9+omULPyeCtADAdBgNVHQ4EFgQUDbJ5YB4VsNVa9pBiP5eFuLwJ IDgwDgYDVR0PAQH/BAQDAgWgMAwGA1UdEwEB/wQCMAAwHQYDVR0lBBYwFAYIKwYBBQUHAwQG CCsGAQUFBwMCMEAGA1UdIAQ5MDcwNQYMKwYBBAGyMQECAQEBMCUwIwYIKwYBBQUHAgEWF2h0 dHBzOi8vc2VjdGlnby5jb20vQ1BTMFoGA1UdHwRTMFEwT6BNoEuGSWh0dHA6Ly9jcmwuc2Vj dGlnby5jb20vU2VjdGlnb1JTQUNsaWVudEF1dGhlbnRpY2F0aW9uYW5kU2VjdXJlRW1haWxD QS5jcmwwgYoGCCsGAQUFBwEBBH4wfDBVBggrBgEFBQcwAoZJaHR0cDovL2NydC5zZWN0aWdv LmNvbS9TZWN0aWdvUlNBQ2xpZW50QXV0aGVudGljYXRpb25hbmRTZWN1cmVFbWFpbENBLmNy dDAjBggrBgEFBQcwAYYXaHR0cDovL29jc3Auc2VjdGlnby5jb20wKQYDVR0RBCIwIIEecnVk b2xwaGZyb2dlckBkcmVhbXNvbHV0aW9uLm5sMA0GCSqGSIb3DQEBCwUAA4IBAQC1wJzDIooQ /d8QbboJmo9BORJHU1GBdq4Z95WaMQSSkbC7ePFwxdVi8GoiBbaRH6DoTiP+2/52MhivEw67 HlDBx16lzjGxE363Hq3t0wfy9GRt845+ddYELfSVj4VKAPDGZqK0t+NHe9vso3pxobr0ZA96 s+vuKN47T3Ms675rFTsvipX8S8HTWeELT8XDg0Aitebifhreq3HRKaRhT6/0NOOmeX1OFaN7 I+G1dtFdCvC6AZAsr05DXwKR0D8ROy0/ctrfAfvd1m/69rgT17cydq35cXEQmMAYXqm5rbOn 6gNH5FKg2Ycajlnjw9qP6CNfIBNOp28U2aNZInpDL5F4MYIFVTCCBVECAQEwgawwgZYxCzAJ BgNVBAYTAkdCMRswGQYDVQQIExJHcmVhdGVyIE1hbmNoZXN0ZXIxEDAOBgNVBAcTB1NhbGZv cmQxGDAWBgNVBAoTD1NlY3RpZ28gTGltaXRlZDE+MDwGA1UEAxM1U2VjdGlnbyBSU0EgQ2xp ZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBTZWN1cmUgRW1haWwgQ0ECEQCf+Zr+s8dn6Dz5Uebn hvekMA0GCWCGSAFlAwQCAwUAoIICeTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqG SIb3DQEJBTEPFw0yMTAzMjYxNDQ2MDhaME8GCSqGSIb3DQEJBDFCBEBMuKhW2QufrO/OK9h+ 458l6ApdhG7ZLJKZT+gkFe6r971FmS0g1LBkLyxjet5sqj6KCaPtqqdWmkFP3vSy4CWdMGwG CSqGSIb3DQEJDzFfMF0wCwYJYIZIAWUDBAEqMAsGCWCGSAFlAwQBAjAKBggqhkiG9w0DBzAO BggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgw gb0GCSsGAQQBgjcQBDGBrzCBrDCBljELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIg TWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEYMBYGA1UEChMPU2VjdGlnbyBMaW1pdGVk MT4wPAYDVQQDEzVTZWN0aWdvIFJTQSBDbGllbnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3Vy ZSBFbWFpbCBDQQIRAJ/5mv6zx2foPPlR5ueG96Qwgb8GCyqGSIb3DQEJEAILMYGvoIGsMIGW MQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdT YWxmb3JkMRgwFgYDVQQKEw9TZWN0aWdvIExpbWl0ZWQxPjA8BgNVBAMTNVNlY3RpZ28gUlNB IENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBAhEAn/ma/rPHZ+g8 +VHm54b3pDANBgkqhkiG9w0BAQEFAASCAgB2vFGMAEJtSV06ANRBu5AhE9PB1fAieFRLhkKs I40Uh5hXaQfM1X8w68vUiCfE1guIzJ3Q7ybQXOUC2Gk38e+orjclEVCilWiWRtnCKT3gEFJW ByotsbRkwNSdF4x4egz57lQpeU2TI5ZsSnW2jD5lFLhBGwVu4YdP8e0Fpa+4sQ2RI17VYVzf 0VPpFaY0k6lo2pnYxJ1Ovrbhz7CfGtdaq/F4Ei7abT8ciKLbL6dLVgtPxBSO/jRbX6Yqko3g urB0IJzjzSObJPdlXjpH8Eo2RTsErZ9mZryTozGQll+Nax36KYtbqGmLkcQ0WpnirsZ111Uf 7pp11nVVoJy7eaZXpT1h9+nz7M16el+srZxM2Sej9IP+takp8lB17VXqELBZ88/PLhohBOqi 5B+RTs34NcVFkphF3CuQ1lw4FdoOS/CEffRi1QqPtbqR41c1sGl6nyrnAUrvuU0Ed5ZwSU1P riEY4Vzp/Sw5NdmaYa+7vOr8arg7yDrOGJmfmuc4U0kD0adL89eZzghc6M+5GL0QcXw2eHoM pJYvNVaBgRUyBi42Y71B84fJoKNfTxC4NWxlScdCTYHrbBYLemgZSjckJYZosJ/ht1+sfeNv GNoRs6vRTPjgPsCoIlR4Wpb3BkyjF8D3x1CPl7u1cV5cAm1jABINZ3JgUAJIrGqk+Y17KAAA AAAAAA== --------------ms040108040003070205070708--