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 1orfOi-0002Zc-Py for pgsql-novice@arkaria.postgresql.org; Sun, 06 Nov 2022 13:09:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1orfOh-0002Rj-2g for pgsql-novice@arkaria.postgresql.org; Sun, 06 Nov 2022 13:09:11 +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 1orfOg-0002Ra-QH for pgsql-novice@lists.postgresql.org; Sun, 06 Nov 2022 13:09:10 +0000 Received: from mail-pj1-x1029.google.com ([2607:f8b0:4864:20::1029]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1orfOf-0002C5-1T for pgsql-novice@lists.postgresql.org; Sun, 06 Nov 2022 13:09:10 +0000 Received: by mail-pj1-x1029.google.com with SMTP id q1-20020a17090a750100b002139ec1e999so8149925pjk.1 for ; Sun, 06 Nov 2022 05:09:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:to:from:content-language:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=vXNuIFz4CnqULC0tzx3UBAHhK2dLvQRL2fwb3RPTr6Y=; b=X/sZ2DTTQ/PJiRiAOJqMDBYXim9gZG9PGX/0FXTeH6DpPz75js8vzG5jXObSZ+KDTt nG+vHiurk1zmhdsvRSSdioPpWJCCZDyqPwB5HmkOuh9UwYYfQoyPmcOPIjZbrEG+nGC3 bxKfJyM8J3w9yuMdJJx42SnUEPBEN/Y9xtGjSYEMJQkGxxnUqDxbJMZ/slvSGGXOhTbP uev64IF4q2ZpZq+k63FDv6w6NCx6gO/URoU/ghGQNjcHjgkKrDY3cQ7aGPvR3/f3lm4x 1RpAjDyYVVroETwSX6u8HtmQnAniv4gFge8P6DK3EIihxdy25efSrRutgF+DkcLVqkgE 0L2w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=subject:to:from:content-language:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=vXNuIFz4CnqULC0tzx3UBAHhK2dLvQRL2fwb3RPTr6Y=; b=gn6ZgFJHzytLD2hDYJJVsq+FPwnkiZ3G+vrxJ+UYSK2BOagFy8D7IzokRVh5W1+uqz wcRD9DOJx+D9t4UdsM9tvfb8zJHbqcX9g9Cq6wRT0LHHr0IqcTxmNM4dUMDC//0U5s66 4JhiShnv5224HS7rxG9WnjIzrTWb02gkeQDsWsX/l/vuJXNR2pEtaamB4FyeY+dsO39c /jc6E+4jfXYJzWodOw3PS11sZ7OztFXE7rpG5xDvrFvEG+EpnlaxN9W0IYl78P9COotz I1zA1BUQNLZXfpUsPDJ5Nlj8JgemNdhXZ4gwICyQekkGHHeh13FleNjfxmvbetrnm8z+ StuA== X-Gm-Message-State: ACrzQf06nBpFuEaoNw5l2Vcp+r8DfMLc1Xvz3upf2XJ2ADh0uB2FXpgH 2OqjpOvb2GZOuT+RH7dRA9WdaPeAPdM= X-Google-Smtp-Source: AMsMyM6qufjc2PMumu65443TR1wM3FKXI28+fvEFA+SOJP/nFxCTQGnMdXY3QPRhZiu2gyxszjNUVg== X-Received: by 2002:a17:90a:5a46:b0:213:cf6e:5f67 with SMTP id m6-20020a17090a5a4600b00213cf6e5f67mr38799201pji.93.1667740146102; Sun, 06 Nov 2022 05:09:06 -0800 (PST) Received: from [10.0.2.15] ([27.57.114.71]) by smtp.gmail.com with ESMTPSA id d16-20020a170902ced000b0017f49b41c12sm3110463plg.173.2022.11.06.05.09.04 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 06 Nov 2022 05:09:05 -0800 (PST) Content-Type: multipart/alternative; boundary="------------fDNo7jQMmddIrl8WOAuT03eg" Message-ID: Date: Sun, 6 Nov 2022 18:39:02 +0530 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.3.3 Content-Language: en-US From: Ankit Kumar Pandey To: pgsql-novice@lists.postgresql.org Subject: Todo item: distinct clause - guidance List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------fDNo7jQMmddIrl8WOAuT03eg Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hi, I was looking for some to-do item to pick up and came across /'Implement DISTINCT clause in window aggregates'. /Can someone please//elaborate what is expectation here? Do feature request still exists as //DISTINCT/ /worked as expected if we try functions like avg(distinct col)?/ / Thanks, Ankit/ / --------------fDNo7jQMmddIrl8WOAuT03eg Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

Hi,

I was looking for some to-do item to pick up and came across 'Implement DISTINCT clause in window aggregates'. Can someone please elaborate what is expectation here? Do feature request still exists asĀ DISTINCT worked as expected if we try functions like avg(distinct col)?

Thanks,

Ankit

--------------fDNo7jQMmddIrl8WOAuT03eg--