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 1kPQz3-00068x-BN for pgsql-docs@arkaria.postgresql.org; Mon, 05 Oct 2020 13:56:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kPQz1-00080G-1K for pgsql-docs@arkaria.postgresql.org; Mon, 05 Oct 2020 13:56:55 +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 1kPQz0-000808-Q6 for pgsql-docs@lists.postgresql.org; Mon, 05 Oct 2020 13:56:54 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kPQyw-0004nX-8d for pgsql-docs@lists.postgresql.org; Mon, 05 Oct 2020 13:56:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1601906207; bh=SYaf2yq7NbqL5z3x7sUZclXSNrdU8MGOvTzF/BeGy1M=; h=X-UI-Sender-Class:From:Subject:Reply-To:To:Date; b=UnpMotVhnn38s1ZJrqnO4tULzFkjG72OTgu08jzJ8aJXZa5ApbBmxjNpNgav/7XCw 4+ywk/rHSHpBPDB+ksHMhNee3ZZIvFS9RvBPX1Dk8yXtyHal8sshu5aWKfEUtNDaL0 WNYpwijHVMoa8Lj2c3dc9xYtPndlEpn8E3Q4yUcg= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [10.1.34.241] ([185.40.248.10]) by mail.gmx.com (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MHG8g-1kCDZX13wW-00DIim for ; Mon, 05 Oct 2020 15:56:47 +0200 From: Thomas Kellerer Subject: Wrong parameter names for make_interval (Postgres 13) Reply-To: pgsql-docs@lists.postgresql.org To: pgsql-docs@lists.postgresql.org Message-ID: <7b154ef0-9f22-90b9-7734-4bf23686695b@gmx.net> Date: Mon, 5 Oct 2020 15:56:46 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:zSWn1f/2iKo7dTteumJxO23yfvVXrlz1Uyc+RkAIgjIfYXJ5xNg dkFaNksFit/XoiXAPxvc2gpvP2GbNNuHKz62+zq5r0pvW8mAUT31pN/BwufJ6/X45fA5TBg fK4i7J6P5S/FsakRMaI8ryXCrHhol+aNNnd+PnOGuKxgo2fJSX1WwnS/FPF9CWlv5dFSuxI lkIlUKrqroUTD7ZawfFTA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:F/KvW9PR89U=:sh/B65jC/kW+xze7slBs4t 00aFSO1OU7YC1v6PMtKoHYfwLr0Vejj8xpH8EMG4cQKkS3omtfJLhkGRdRXqqzNJrnJuF7+8E QxQd3Sq42znj2K6f8URSXLGwCtdt6bKrLNM6KM0+8qrFSb85ijajAHjvE+pSUXkBvcwRsW6e+ RPHP2m/4kFpGOpxNUrQ+yqT6+AOln6axKrVi25mPx4KhER/yulEj1qrCMHJ+45l8EMgsGNnDS rLC1A9ORgPWN/eoTFG/pibUvmIhWldZi3z1s0jspKWDMfzXT0MvFdjvCdqo45OAPQ6G8WUZJ/ 74KB2EyDytFbRLEmezYFpOczmSY1W5l8JEshEgQWtlrIyz7Mw+9H3eZbh8yeoTYxYf0DentRH LEk3Q6YCuyb9JhampoLKMvmFJTxBC0AJlbRb+Fpmh9LF4xzNHkV6ifyk6LB4qhspbvQk98mnT gCKtXoOgCWlU1dwAfsrCkuv0sMh9wNxEwi36q0ZGLoPU1yYJhITUiyDnyJ5QMEygeyTqPOduC NZGmJP5zsQGWIfrIr2mVBN3ZG/0haVwL/dtF9jMsd99VhJrkkPIhldy/toVPni/KlL4i7Rwbv zk08FYvVNitle3fhhwZyy07Pj1P09lbgvHK8JPpheEkJiFzUqa3NzRiA4T9jfbsVKKFLButZK Q858uXbAQqsFVccibVoNDfUnLpfqzAH0CJq1zqiiEkV0Kh+nq4rAMaH/NJmbVxG2zHG3Ovbq5 dH0ww29A/JQgIAiOV/gjmvBUc8pQHFSs6i0R0WoqJX1ZYlQkvfVLWQq0SjW1K/EazN6jHEg6q XJ9PROBK2bia/IvicYRTqumP4/7KM+kvw3P3+WYMPoC+z2Jr1HvdIp4fJiqOJsSv5sWvo7AvX AkTMcGnvP3kUTYbZ9fXTYX5TNBWUnxBuhbTgqsVJP+tjPSRutmmzWQ/uW1Vn/HIQcnJWboaIz xNimCwUP4vurieLmjrpDSpOTlkHM3N7QmNT4a2jegfM2BxK3q8fFZ0a2zjmEFCjGGWyo3szrH gXTZ0NvI6vI93A1yjPt9kBpWBs+57YZ8QKj56HEu4rTK7V4XlwsKdRHFx7Vb3XdYtK5EvC94J oiCzat2aeyUsMZ8bnyi2mEx5oWhD+KxIUtsmZLr09sJJEA1EGTR2+/Jen0XtkB5i0GMlaCyPk THLw5Yc/DGWngrBKxSUs7N/geANUHRVlpux7ev2WZcbZsWmuVsMDOEjzt0agCWfBY1zEe5d0/ HxORMXyQ7I1aXdTGb List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk There is a typo in the parameter names of the make_interval() function. The parameter names are all defined with plural, not singular as it is shown in the Postgres 13 manual. So instead of make_interval ( [ year int [, month int [, week int [, day int [, hour int [, min int [, sec double precision ]]]]]]] ) it should be make_interval ( [ years int [, months int [, weeks int [, days int [,hours int [, mins int [, secs double precision ]]]]]]] ) Thomas