| 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 | Resend email |
| 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 |
| 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? |