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 1p26Xk-0000xc-HS for pgsql-docs@arkaria.postgresql.org; Mon, 05 Dec 2022 08:09:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p26Xj-0005jg-9p for pgsql-docs@arkaria.postgresql.org; Mon, 05 Dec 2022 08:09:39 +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 1p26Xi-0005iV-SI for pgsql-docs@lists.postgresql.org; Mon, 05 Dec 2022 08:09:39 +0000 Received: from mail-ej1-x62c.google.com ([2a00:1450:4864:20::62c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p26Xg-0000NS-Pb for pgsql-docs@lists.postgresql.org; Mon, 05 Dec 2022 08:09:38 +0000 Received: by mail-ej1-x62c.google.com with SMTP id x22so3419800ejs.11 for ; Mon, 05 Dec 2022 00:09:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=ACAghNO6CUDJmyb1wb2MVGfEL4ZsMuG6Ul8qYnTV84A=; b=VkMCnchuPU0mr2bswlRHGyYMbHQMD7O18aoipJEGsln5Uy8ZffKJKcrr6QE77BueKS CyKRJaRTsIH462uBw9de0AOTP0XTHeoPkPl9mR02Ky2lrcp9BPeISS1IakakdMUEyt57 9c0IbemyJZz1qIn8PFC1mqoa00gwyemDVAMJskk69X9lAoxQwXGOzTgsqbc20Y2XyYpD JBJR6CZ8VbVCguRk2XKOZd91IZuBV2eboOikCOmmHhwvXW1D0iIMe/jfwfPMySMWYB5K y752PXdOCcqcv5eDLT4n8UbD1XrMYX7W83hgtEtMAKq/EZsTHRDFQievfB19UxouVYb2 ZItQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=ACAghNO6CUDJmyb1wb2MVGfEL4ZsMuG6Ul8qYnTV84A=; b=rXo7bu0oERh50ZoLYq4uVKQJuMLjBFz1J8b1HARi8KTNDGDuTboTQxhCxlcN4wJuu/ 3q6wfvcNNhLl98CM541HS6Onqe9exP6h07fG6P6DQrJ1PYrEG28EhPKcb/7WUGTfT0Sf CiTyTAFZCWhrEYn8ldT8h4TkI+jqMRJuXOsj09W2nth0o9mmJ63nzuZHYZiv9eRpAc1K fsa6MdhIiSH1R+/1ta3EG1ESQogr1DEjPhxT8P0tZculQP2SozV5EtNExM5M/noHHv3S iarj3AN3vsnHEG0oHQSLV1MeXetql/ekPLwH+cupa4WTPA30P68jRxDr/jgB/xSgjSKW sWHg== X-Gm-Message-State: ANoB5pkfVJMQKWtQeLIamCIj85B9xhICHbOrWnj1d4E7BOgGLZLlPuPO Lw4F1DX5ILQMKATZfpVEnwJfeA== X-Google-Smtp-Source: AA0mqf7EAnbcdLF9iv9XlJmH3uFmiMQMuuWdEuAsq7j2JKlCv6Lsqa74i2PRcrcmeurvkE1D3SjTow== X-Received: by 2002:a17:906:6c7:b0:78d:4061:5e1b with SMTP id v7-20020a17090606c700b0078d40615e1bmr59777635ejb.47.1670227775758; Mon, 05 Dec 2022 00:09:35 -0800 (PST) Received: from localhost.localdomain ([2001:871:5e:b47b:e706:88d7:ceb1:a099]) by smtp.gmail.com with ESMTPSA id gi20-20020a1709070c9400b0077d6f628e14sm5994417ejc.83.2022.12.05.00.09.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 05 Dec 2022 00:09:35 -0800 (PST) Message-ID: <181bc5aade34400ff9173eb36879a8cc716c2d7a.camel@cybertec.at> Subject: Re: wiki postgresql Window_function some todo items is done? From: Laurenz Albe To: Ian Lawrence Barwick , jian he Cc: pgsql-docs@lists.postgresql.org Date: Mon, 05 Dec 2022 09:09:34 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2022-12-05 at 15:59 +0900, Ian Lawrence Barwick wrote: > 2022年12月5日(月) 13:32 jian he : > > > > Hi, > > > > https://wiki.postgresql.org/wiki/Todo#Window_Functions > > > > > Implement full support for window framing clauses > > > > > > In addition to done clauses described in the latest doc, these clauses are not implemented yet. > > > > > > RANGE BETWEEN ... PRECEDING/FOLLOWING > > > EXCLUDE > > > > I think this TODO item is done? > > The entire section looks like it's very out-of-date. The emails it links to are > all from 2008, which is around the time (8.4 IIRC) when window functions were > first added. > > > aslo > > The "latest doc" binded link (developer.postgresql.org/pgdocs/postgres/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS) is not working. > > That URL structure is also pretty ancient; the current link is: > >   https://www.postgresql.org/docs/devel/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS Thanks for the report and the check. I have taken the liberty to remove the TODO list item. Yours, Laurenz Albe