agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Jürgen Purtz <juergen@purtz.de>
To: pgsql-hackers@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Re: [HACKERS] Unsupported feature F867: WITH TIES
Date: Fri, 26 Aug 2016 11:58:52 -0400
Message-ID: <6a6214a6-68dc-e828-527c-c0509d9aee92@2ndquadrant.com> (raw)
In-Reply-To: <5ab043b6-686d-b907-6672-7d39738ebd6f@purtz.de>
References: <5ab043b6-686d-b907-6672-7d39738ebd6f@purtz.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
view thread (2+ messages)
Message-ID: <6a6214a6-68dc-e828-527c-c0509d9aee92@2ndquadrant.com>
Permalink: ../6a6214a6-68dc-e828-527c-c0509d9aee92@2ndquadrant.com/
Also on: postgresql.org/message-id/6a6214a6-68dc-e828-527c-c0509d9aee92@2ndquadrant.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: peter.eisentraut@2ndquadrant.com, juergen@purtz.de, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Unsupported feature F867: WITH TIES
In-Reply-To: <6a6214a6-68dc-e828-527c-c0509d9aee92@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox