FETCH FIRST clause WITH TIES option

From: Surafel Temesgen <surafel3000(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: FETCH FIRST clause WITH TIES option
Date: 2018-10-26 10:28:31
Message-ID: CALAY4q9ky7rD_A4vf=FVQvCGngm3LOes-ky0J6euMrg=_Se+ag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

hello ,

The WITH TIES keyword is sql standard that specifies any peers of retained
rows

to retained in the result set too .which means according to ordering key
the result set can includes additional rows which have ties on the last
position, if there are any and It work with ORDER BY query

The attach patch is a finished implementation of it except it did not have
a regression test because am not sure of changing the test data set for it
and I can’t find fetch first clause regression test too.

Regards

Surafel

Attachment Content-Type Size
fetch_first_with_ties_v1.patch text/x-patch 25.5 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Surafel Temesgen 2018-10-26 10:36:21 Re: COPY FROM WHEN condition
Previous Message Tom Lane 2018-10-26 10:20:13 Re: Should pg 11 use a lot more memory building an spgist index?