Unsupported feature F867: WITH TIES

From: Jürgen Purtz <juergen(at)purtz(dot)de>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Unsupported feature F867: WITH TIES
Date: 2016-08-26 13:06:42
Message-ID: 5ab043b6-686d-b907-6672-7d39738ebd6f@purtz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-sql

Actually we don't support the SQL feature F867 "FETCH FIRST clause: WITH
TIES option". On the other side we support the window function "rank()"
which acts like the "WITH TIES option". My questions are: Is it hard to
implement the "WITH TIES option"? Are there plans for a realization /
how do we decide in general what to do next? Differs the semantic of the
"WITH TIES option" significantly from the "rank()" window function or
can we treat it as some kind of 'syntactical sugar'?

Regards, Jürgen Purtz


Browse pgsql-hackers by date

  From Date Subject
Next Message Aleksander Alekseev 2016-08-26 13:07:44 Re: [Patch] RBTree iteration interface improvement
Previous Message Fujii Masao 2016-08-26 13:03:28 Re: pg_xlogdump fails to handle WAL file with multi-page XLP_FIRST_IS_CONTRECORD data

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2016-08-26 15:58:52 Re: [HACKERS] Unsupported feature F867: WITH TIES
Previous Message Harald Fuchs 2016-08-24 08:03:27 Re: Display group title only at the first record within each group