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 1k4N2n-000749-0e for pgsql-sql@arkaria.postgresql.org; Sat, 08 Aug 2020 11:29:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k4N2j-0003x5-Kt for pgsql-sql@arkaria.postgresql.org; Sat, 08 Aug 2020 11:29:41 +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 1k4N2j-0003wx-CZ for pgsql-sql@lists.postgresql.org; Sat, 08 Aug 2020 11:29:41 +0000 Received: from forward500j.mail.yandex.net ([5.45.198.250]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k4N2h-0001Tm-7g for pgsql-sql@lists.postgresql.org; Sat, 08 Aug 2020 11:29:40 +0000 Received: from mxback2q.mail.yandex.net (mxback2q.mail.yandex.net [IPv6:2a02:6b8:c0e:40:0:640:9c8c:4946]) by forward500j.mail.yandex.net (Yandex) with ESMTP id D69FE11C165D; Sat, 8 Aug 2020 14:29:36 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback2q.mail.yandex.net (mxback/Yandex) with ESMTP id JwhAhHtXjM-TZh42RLf; Sat, 08 Aug 2020 14:29:36 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1596886176; bh=CMTx+RdIGSbbq7B0QRi67jlSF+cBxbKqNry35/GsP2w=; h=References:Date:Message-Id:Subject:In-Reply-To:To:From; b=g8yQZgACEy/lvEdvNeBtjm+K+0R7LOAmLurnsm0rb5zIZNWbDexTdubhhy3W7izcJ Wz4e3Ybzp5ECaCHr9UPn5Z6QKS2AxMvHm9WawDUzt4Qug0WiexPQnf22cc3G86GWCM AdSju/BW3YIuYdEMiig+ct2IZ8gn1kHAzJiepajA= Authentication-Results: mxback2q.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by vla1-fadba9086fdf.qloud-c.yandex.net with HTTP; Sat, 08 Aug 2020 14:29:35 +0300 From: Samed YILDIRIM To: Torsten Grust , pgsql-sql In-Reply-To: References: Subject: Re: Group by a range of values MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Sat, 08 Aug 2020 14:29:35 +0300 Message-Id: <615631596886135@mail.yandex.com.tr> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj48ZGl2PkhpLDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkFub3RoZXIgKGFuZCBsZXNzIG9w dGltaXNlZCA6KSkgYWx0ZXJuYXRpdmU7PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+PGRpdj5wZ3Nx bC1zcWw9IyBzZWxlY3QgbSxkZW5zZV9yYW5rKCkgb3ZlciAob3JkZXIgYnkgKG0tMSkvMykgZnJv bSBnZW5lcmF0ZV9zZXJpZXMoMSwxMCkgbTs8L2Rpdj48ZGl2Pm0gfCBkZW5zZV9yYW5rPC9kaXY+ PGRpdj4tLS0tKy0tLS0tLS0tLS0tLTwvZGl2PjxkaXY+MSB8IDE8L2Rpdj48ZGl2PjIgfCAxPC9k aXY+PGRpdj4zIHwgMTwvZGl2PjxkaXY+NCB8IDI8L2Rpdj48ZGl2PjUgfCAyPC9kaXY+PGRpdj42 IHwgMjwvZGl2PjxkaXY+NyB8IDM8L2Rpdj48ZGl2PjggfCAzPC9kaXY+PGRpdj45IHwgMzwvZGl2 PjxkaXY+MTAgfCA0PC9kaXY+PGRpdj4oMTAgcm93cyk8L2Rpdj48ZGl2PsKgPC9kaXY+PC9kaXY+ PC9kaXY+PGRpdj5CZXN0IHJlZ2FyZHMuPC9kaXY+PGRpdj5TYW1lZCBZSUxESVJJTTwvZGl2Pjxk aXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+MDEuMDguMjAyMCwgMTU6 MzUsICJUb3JzdGVuIEdydXN0IiAmbHQ7dG9yc3Rlbi5ncnVzdEBnbWFpbC5jb20mZ3Q7OjwvZGl2 PjxibG9ja3F1b3RlPjxkaXY+PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6J2FyaWFsJyAsIHNhbnMt c2VyaWYiPjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OidhcmlhbCcgLCBzYW5zLXNlcmlmIj5IaSw8 L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTonYXJpYWwnICwgc2Fucy1zZXJpZiI+wqA8L2Rp dj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTonYXJpYWwnICwgc2Fucy1zZXJpZiI+bWF5YmUgdGhp cyBkb2VzIHRoZSBqb2IgYWxyZWFkeSAoLyBpcyBpbnRlZ2VyIGRpdmlzaW9uKTo8L2Rpdj48ZGl2 IHN0eWxlPSJmb250LWZhbWlseTonYXJpYWwnICwgc2Fucy1zZXJpZiI+wqA8L2Rpdj48ZGl2IHN0 eWxlPSJmb250LWZhbWlseTonYXJpYWwnICwgc2Fucy1zZXJpZiI+U0VMRUNUIGksIDEgKyAoaS0x KSAvIDPCoDwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OidhcmlhbCcgLCBzYW5zLXNlcmlm Ij5GUk9NwqAgwqBnZW5lcmF0ZV9zZXJpZXMoMSwxMCkgQVMgaTs8L2Rpdj48ZGl2IHN0eWxlPSJm b250LWZhbWlseTonYXJpYWwnICwgc2Fucy1zZXJpZiI+wqA8L2Rpdj48ZGl2IHN0eWxlPSJmb250 LWZhbWlseTonYXJpYWwnICwgc2Fucy1zZXJpZiI+QW4gZXhwcmVzc2lvbiBsaWtlIChpLTEpIC8g MyBjb3VsZCwgb2YgY291cnNlLCBhbHNvIGJlIHVzZWQgYXMgcGFydGl0aW9uaW5nIGNyaXRlcmlv biBpbiBHUk9VUCBCWSBhbmQvb3Igd2luZG93IGZ1bmN0aW9ucy48L2Rpdj48ZGl2IHN0eWxlPSJm b250LWZhbWlseTonYXJpYWwnICwgc2Fucy1zZXJpZiI+wqA8L2Rpdj48ZGl2IHN0eWxlPSJmb250 LWZhbWlseTonYXJpYWwnICwgc2Fucy1zZXJpZiI+Q2hlZXJzLDwvZGl2PjxkaXYgc3R5bGU9ImZv bnQtZmFtaWx5OidhcmlhbCcgLCBzYW5zLXNlcmlmIj7CoCDigJRUPC9kaXY+PC9kaXY+PC9kaXY+ wqA8ZGl2PjxkaXY+T24gU2F0LCBBdWcgMSwgMjAyMCBhdCAyOjE1IFBNIE1pa2UgTWFydGluICZs dDs8YSBocmVmPSJtYWlsdG86cmVkdHV4MUBnbWFpbC5jb20iPnJlZHR1eDFAZ21haWwuY29tPC9h PiZndDsgd3JvdGU6PC9kaXY+PGJsb2NrcXVvdGUgc3R5bGU9ImJvcmRlci1sZWZ0LWNvbG9yOnJn YiggMjA0ICwgMjA0ICwgMjA0ICk7Ym9yZGVyLWxlZnQtc3R5bGU6c29saWQ7Ym9yZGVyLWxlZnQt d2lkdGg6MXB4O21hcmdpbjowcHggMHB4IDBweCAwLjhleDtwYWRkaW5nLWxlZnQ6MWV4Ij48ZGl2 PjxkaXY+U2F5IEkgaGF2ZSBhIGZpZWxkIG9mIGludHMsIGFzIGZvciBleGFtcGxlIGNyZWF0ZWQg Ynkgd2l0aCBvcmRpbmFsaXR5IG9yIGdlbmVyYXRlX3NlcmllcywgaXMgaXQgcG9zc2libGUgdG8g Z3JvdXAgYnkgYSByYW5nZT8gZXE8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj4xLDIsMyw0LDUsNiw3 LDgsOSwxMDwvZGl2PjxkaXY+c3RlcCAzPC9kaXY+PGRpdj5zbyBvdXRwdXQgaXM8L2Rpdj48ZGl2 PsKgPC9kaXY+PGRpdj4xIDE8L2Rpdj48ZGl2PjIgMTwvZGl2PjxkaXY+MyAxPC9kaXY+PGRpdj40 IDI8L2Rpdj48ZGl2PjUgMjwvZGl2PjxkaXY+NiAyPC9kaXY+PGRpdj43IDM8L2Rpdj48ZGl2Pjgg MzwvZGl2PjxkaXY+OSAzPC9kaXY+PGRpdj4xMCA0PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+dGhh bmtzPC9kaXY+PC9kaXY+PC9ibG9ja3F1b3RlPjwvZGl2PsKgPGRpdj7CoDwvZGl2Pi0tPGRpdj48 ZGl2PjxkaXY+PGRpdj48ZGl2Pjxmb250IGZhY2U9Im1vbm9zcGFjZSwgbW9ub3NwYWNlIj58IFRv cnN0ZW4gR3J1c3Q8YnIgLz58IDxhIGhyZWY9Im1haWx0bzpUb3JzdGVuLkdydXN0QGdtYWlsLmNv bSI+VG9yc3Rlbi5HcnVzdEBnbWFpbC5jb208L2E+PC9mb250PjxiciAvPsKgPC9kaXY+PC9kaXY+ PC9kaXY+PC9kaXY+PC9kaXY+PC9ibG9ja3F1b3RlPg==