pgsql: WITH TIES: number of rows is optional and defaults to one

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: WITH TIES: number of rows is optional and defaults to one
Date: 2020-05-18 23:29:55
Message-ID: E1japCl-00036q-CR@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

WITH TIES: number of rows is optional and defaults to one

FETCH FIRST .. ONLY implements this correctly, but we missed to include
it for FETCH FIRST .. WITH TIES in commit 357889eb17bb.

Author: Vik Fearing
Discussion: https://postgr.es/m/6aa690ef-551d-e24f-2690-c38c2442947c@postgresfriends.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c301c2e739c642199f9e4c62d867dc7bd5ef0fd1

Modified Files
--------------
src/backend/parser/gram.y | 8 ++++++++
src/test/regress/expected/limit.out | 17 +++++++++++++++++
src/test/regress/sql/limit.sql | 5 +++++
3 files changed, 30 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Geoghegan 2020-05-19 22:06:59 pgsql: Reconsider nbtree page deletion assertion.
Previous Message Tom Lane 2020-05-18 20:10:09 pgsql: Stamp 13beta1.