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 1hNiD9-0000Ci-4j for pgsql-hackers@arkaria.postgresql.org; Mon, 06 May 2019 18:19:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hNiD7-0000Z5-SL for pgsql-hackers@arkaria.postgresql.org; Mon, 06 May 2019 18:19:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hNiD7-0000Xb-IU for pgsql-hackers@lists.postgresql.org; Mon, 06 May 2019 18:19:33 +0000 Received: from mail-pg1-x532.google.com ([2607:f8b0:4864:20::532]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hNiD5-0004LZ-8r for pgsql-hackers@postgresql.org; Mon, 06 May 2019 18:19:33 +0000 Received: by mail-pg1-x532.google.com with SMTP id e6so6864700pgc.4 for ; Mon, 06 May 2019 11:19:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=illuminatedcomputing-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=ln/BWktgLwUu1oFTtAj8+fI1J6TcGEC/5oXqC5TEDJ8=; b=bDAfaC+NpgSRV2D1C06eo5Nrn49Tob/AppDKsFfwDHm8QRAZ5iTCx+UO3lCc2lxuVE rU3UGBvTJo/Y51pqLVXbam8KeOFXx9hRZFnMI5gaAfPH2e3zoWJmNbwPqWtpWYR3naQU U0sfxtsmiSyQEEkilUkP6rzYbwNSQPPWfClt6B6icG33ly60sDIR1r8bvtRF6mcvsj/5 pgQbQIe1qZbh8u/CxRJSOxzqw/EUrNeXQ9jxNBTWLw+ViAk9MhL9EIDsTryLwhTIGFfp eN8/gVUCWsSp4rsJ6B4J4mzHTfLGWqB9SLeaaTLRF679BxCvl73S407LJFhESU3h+VsQ +XNQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=ln/BWktgLwUu1oFTtAj8+fI1J6TcGEC/5oXqC5TEDJ8=; b=VqGIyiVh9BmIsvr/VGRl7R2FdESznF2fHvc3gyAFBzLfyLZfPRRnnl3llzweKrbpbI WTSsZWE7ktgpZZcv2ej0Z3VRfF+azKH5eJKSNObgyhHF2AE+4ZpQO4FK1PnQFtbH+SGh CYdPC34huTBn9zXHRE5KfQOMnwFbSMWsK7ukmfCof6eHs8W+WpKPzU8wxVhpCvu961+m MWXPeBMLOStj1CAaia5uhHzXzJmMFU9swJ7U4uSEIB+xYSfVfmG+miLv/A80C13G0itc BjmNcfS6jCNABkPy6/bF56IPm+nvFFLvznA03TlBcFEkp8cdDHUXIPzD9VHoFBXR4Tza TcQQ== X-Gm-Message-State: APjAAAXo5zmYoi4nECiOPYh71bWERhgiLtoOhWGrAasl7tCrtzBRuWaB Bx8XCBp0CXeEJyIqp+98zWnM4bixpPM= X-Google-Smtp-Source: APXvYqy2vnJ5INfwGGI70+sraiWgqZQSjk/ngvD0AHTMiLE75guBGzOPZUwCiZIffqLr/57ETUJztw== X-Received: by 2002:a63:8b4b:: with SMTP id j72mr33740549pge.318.1557166768885; Mon, 06 May 2019 11:19:28 -0700 (PDT) Received: from [192.168.2.201] (static-50-53-109-254.bvtn.or.frontiernet.net. [50.53.109.254]) by smtp.googlemail.com with ESMTPSA id y17sm16366390pfb.161.2019.05.06.11.19.27 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 06 May 2019 11:19:28 -0700 (PDT) Subject: Re: range_agg To: David Fetter Cc: Pgsql Hackers References: <16d71dc8-34cf-5ebd-1ce5-ccd93c0a14f9@illuminatedcomputing.com> <20190504014147.GC28936@fetter.org> From: Paul Jungwirth Message-ID: <16a2d956-f9da-6bed-6473-de9d1ec0a428@illuminatedcomputing.com> Date: Mon, 6 May 2019 11:19:27 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: <20190504014147.GC28936@fetter.org> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 5/3/19 6:41 PM, David Fetter wrote: > This suggests two different ways to extend ranges over aggregation: > one which is a union of (in general) disjoint intervals, two others > are a union of intervals, each of which has a weight. > . . . > I think the cases above, or at least the first two of them, should be > available. They could be called range_agg, weighted_range_agg, and > covering_range_agg. Thanks David! I think these two new functions make sense. Before I implement them too I wonder if anyone else has uses for them? Thanks, -- Paul ~{:-) pj@illuminatedcomputing.com