agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedUnsupported feature F867: WITH TIES
2+ messages / 2 participants
[nested] [flat]
* Unsupported feature F867: WITH TIES
@ 2016-08-26 13:06 Jürgen Purtz <juergen@purtz.de>
0 siblings, 1 reply; 2+ messages in thread
From: Jürgen Purtz @ 2016-08-26 13:06 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org; 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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [HACKERS] Unsupported feature F867: WITH TIES
@ 2016-08-26 15:58 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
parent: Jürgen Purtz <juergen@purtz.de>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2016-08-26 15:58 UTC (permalink / raw)
To: Jürgen Purtz <juergen@purtz.de>; pgsql-hackers@postgresql.org; pgsql-sql
On 8/26/16 9:06 AM, Jürgen Purtz wrote:
> 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'?
LIMIT/FETCH FIRST works at a level that is quite far removed from data
type semantics, which is what you'd need to have handy to compute ties.
LIMIT basically just tells the executor to stop after getting a certain
number of rows.
So implementing WITH TIES would be very difficult in the current setup.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-08-26 15:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-08-26 13:06 Unsupported feature F867: WITH TIES Jürgen Purtz <juergen@purtz.de>
2016-08-26 15:58 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox