Re: FETCH FIRST clause PERCENT option

From: Surafel Temesgen <surafel3000(at)gmail(dot)com>
To: vik(dot)fearing(at)2ndquadrant(dot)com
Cc: Mark Dilger <hornschnorter(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, andrew(at)tao11(dot)riddles(dot)org(dot)uk
Subject: Re: FETCH FIRST clause PERCENT option
Date: 2018-11-30 07:23:42
Message-ID: CALAY4q9ootpMMmMBG-5zDdZaKRceDJP_FPB0ggX5nYf7P6PLpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Nov 25, 2018 at 3:05 PM Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>
wrote:

>
> I assume you meant 200 rows there, but the correct number of rows to
> return is 203 for that query. Please fix it.
>

Attach is a patch that include a fix for it
regards
Surafel

Attachment Content-Type Size
fetch-wth-percent-v6.patch text/x-patch 37.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2018-11-30 07:25:30 Re: Planning time of Generic plan for a table partitioned into a lot
Previous Message Tatsuo Ishii 2018-11-30 07:21:20 Re: idle-in-transaction timeout error does not give a hint