Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fjURr-0004X4-97 for pgsql-hackers@arkaria.postgresql.org; Sat, 28 Jul 2018 19:00:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fjURm-00037M-Hp for pgsql-hackers@arkaria.postgresql.org; Sat, 28 Jul 2018 19:00:10 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fjURl-00037F-UZ for pgsql-hackers@lists.postgresql.org; Sat, 28 Jul 2018 19:00:10 +0000 Received: from xvm-110-146.dc2.ghst.net ([46.226.110.146] helo=fetter.org) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fjURc-000301-St for pgsql-hackers@postgresql.org; Sat, 28 Jul 2018 19:00:08 +0000 Received: by fetter.org (Postfix, from userid 1001) id AD1FB41CD8; Sat, 28 Jul 2018 20:59:58 +0200 (CEST) Date: Sat, 28 Jul 2018 20:59:58 +0200 From: David Fetter To: Oliver Ford Cc: Pg Hackers , Krasiyan Andreev Subject: Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Message-ID: <20180728185958.GP17411@fetter.org> References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="Ls2Gy6y7jbHLe9Od" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Ls2Gy6y7jbHLe9Od Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Jul 13, 2018 at 01:52:00PM +0100, Oliver Ford wrote: > Adds the options RESPECT/IGNORE NULLS (null treatment clause) and FROM > FIRST/LAST to the non-aggregate window functions. Please find attached an updated version for OID drift. Best, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate --Ls2Gy6y7jbHLe9Od Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0001-RESPECT-IGNORE-NULLS-FIRST-LAST-in-windowing-functio.patch"