Re: FETCH FIRST clause PERCENT option - Mailing list pgsql-hackers

From Ryan Lambert
Subject Re: FETCH FIRST clause PERCENT option
Date
Msg-id CAN-V+g_pu2cgrM03rwU6y1J2tAMiaVN27Gjv5N6iN7M9_U5Usw@mail.gmail.com
Whole thread Raw
In response to Re: FETCH FIRST clause PERCENT option  (Surafel Temesgen <surafel3000@gmail.com>)
List pgsql-hackers
Surafel,

The patch did not did it automatically. Its query writer obligation to do that currently      

Ok.

Your latest patch [1] passes make installcheck-world, I didn't test the actual functionality this round.

   plan = (Plan *) make_limit(plan,
    subparse->limitOffset,
-   subparse->limitCount);
+   subparse->limitCount,
+   subparse->limitOption);
 

I assume the limit percentage number goes into subparse->limitCount?  If so, I don't see that documented.  Or does this truly only store the count?

The remainder of the code seems to make sense.  I attached a patch with a few minor changes in the comments.  I need to go back to my notes and see if I covered all the testing I had thought of, I should get to that later this week.


Ryan Lambert


Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: remove "msg" parameter from convert_tuples_by_name
Next
From: Alvaro Herrera
Date:
Subject: Re: no default hash partition