Re: Minor quibble with description of WINDOW clause

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: eggyknap <eggyknap(at)gmail(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Minor quibble with description of WINDOW clause
Date: 2013-06-07 04:11:30
Message-ID: 12795.1370578290@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

eggyknap <eggyknap(at)gmail(dot)com> writes:
> The way the WINDOW clause docs are currently worded, it's clear from the
> grammar tree that such clauses come toward the end of the query. But this
> phrase made me wonder, incorrectly, whether they were supposed to come before
> calls to window functions, somehow:

> "...where window_name is a name that can be referenced from subsequent window
> definitions or OVER clauses"

> See http://www.postgresql.org/docs/9.3/static/sql-select.html#SQL-WINDOW for
> the full context.

> I'd have preferred to see "...from OVER clauses or subsequent window
> definitions", which the attached simple patch does. And if I'm the only one
> that likes the idea of such a change, I'll gladly go away quietly. :)

I think you're right. Applied and back-patched.

regards, tom lane

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Eric Howe 2013-06-07 18:32:14 Missing date_trunc docs
Previous Message Peter Eisentraut 2013-06-07 01:04:27 Re: VALUES lists aliases