Re: Making the subquery alias optional in the FROM clause

2023-10-01 Thread Erwin Brandstetter
On Mon, 2 Oct 2023 at 00:33, Dean Rasheed wrote: > The only place that exposes the eref's made-up relation name is the > existing query deparsing code in ruleutils.c, which uniquifies it and > generates SQL spec-compliant output. For example: > I ran into one other place: error messages.

Re: PG 16 draft release notes ready

2023-08-18 Thread Erwin Brandstetter
RANGE mode is specified or would be default, but unnecessary (David Rowley, Erwin Brandstetter) Thanks, Erwin On Sat, 19 Aug 2023 at 04:02, Bruce Momjian wrote: > I have completed the first draft of the PG 16 release notes. You can > see the output here: > > https://momjian.us/pgsq

Re: Allow WindowFuncs prosupport function to use more optimal WindowClause options

2022-10-17 Thread Erwin Brandstetter
On Thu, 13 Oct 2022 at 02:34, David Rowley wrote: > On Wed, 12 Oct 2022 at 16:33, Vik Fearing wrote: > > Per spec, the ROW_NUMBER() window function is not even allowed to have a > > frame specified. > > > > b) The window framing clause of WDX shall not be present. > > > > Also, the

Re: Allow WindowFuncs prosupport function to use more optimal WindowClause options

2022-10-11 Thread Erwin Brandstetter
On Wed, 12 Oct 2022 at 05:33, Vik Fearing wrote: > On 10/12/22 04:40, David Rowley wrote: > > I've not really done any analysis into which other window functions > > can use this optimisation. The attached only adds support to > > row_number()'s support function and only converts exactly "RANGE