Feedback-ID: ia2694551:Fastmail
Date: Mon, 10 Mar 2025 07:08:39 +0100
From: =?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@alvh.no-ip.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David Rowley <dgrowleyml@gmail.com>,
	pgsql-hackers@lists.postgresql.org
Subject: Re: Printing window function OVER clauses in EXPLAIN
Message-ID: <202503100608.ktmgfoerjfqs@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <641586.1741569208@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/202503100608.ktmgfoerjfqs%40alvherre.pgsql>
Precedence: bulk

On 2025-Mar-09, Tom Lane wrote:

> David Rowley <dgrowleyml@gmail.com> writes:
> > What are your thoughts on being a bit more brief with the naming and
> > just prefix with "w" instead of "window"? Looking at window.out, I see
> > that the EXPLAIN output does become quite a bit wider than before. I
> > favour the idea of saving a bit of space.  There is an example in
> > src/sgml/advanced.sgml that has "OVER w", so it does not seem overly
> > strange to me to name them "w1", "w2", etc.
> 
> OK by me, any objections elsewhere?

WFM.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/