Horton

Re: Fix for FETCH FIRST syntax problems

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Peter Geoghegan <pg@bowt.ie>, Vik Fearing <vik.fearing@2ndquadrant.com>, Andrew Gierth <andrew@tao11.riddles.org.uk>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2018-05-22T14:22:20Z
Lists: pgsql-hackers 
On Tue, May 22, 2018 at 5:59 AM, Robert Haas <robertmhaas@gmail.com> wrote:

> If we start routinely
> back-patching things that fall into that category, we will certainly
> manage to destabilize older releases on a regular basis.
>

Just because something is bad if done in excess doesn't mean specific
moderate partaking is bad too.

We actually did backpatch the NaN stuff and reverted that because, for me,
it was a silent change of functioning behavior.​  I find the decision to
back-patch this syntax oversight considerably more obvious than that one
was.

David J.

Commits

  1. Fix SQL:2008 FETCH FIRST syntax to allow parameters.

  2. SQL:2008 alternative syntax for LIMIT/OFFSET: