Postgres Pro
Downloads
Home   >   mailing lists

Re: FETCH FIRST clause WITH TIES option - Mailing list pgsql-hackers

From Robert Haas
Subject Re: FETCH FIRST clause WITH TIES option
Date
Msg-id CA+TgmoaCO14q0cVkZpntRh+0wQArO6mF14uF6hZ_QcdnfHDR6Q@mail.gmail.com
Whole thread Raw
In response to Re: FETCH FIRST clause WITH TIES option  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: FETCH FIRST clause WITH TIES option
List pgsql-hackers
Tree view 
On Mon, Oct 29, 2018 at 12:48 PM Andrew Gierth
<andrew@tao11.riddles.org.uk> wrote:
> Then FETCH FIRST N WITH TIES becomes "stop when the expression
>   rank() over (order by ...) <= N
> is no longer true" (where the ... is the existing top level order by)

Wouldn't that be wicked expensive compared to something hard-coded
that does the same thing?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pg_promote not marked as parallel-restricted in pg_proc.dat
Next
From: Pavel Stehule
Date:
Subject: Re: ToDo: show size of partitioned table