Horton

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

Alvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: c301c2e739c642199f9e4c62d867dc7bd5ef0fd1
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2020-05-18T23:28:46Z
Releases: 13.0 
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

Files

PathChange+/−
src/backend/parser/gram.y modified +8 −0
src/test/regress/expected/limit.out modified +17 −0
src/test/regress/sql/limit.sql modified +5 −0

Discussion