Re: FETCH FIRST clause PERCENT option

From: Surafel Temesgen <surafel3000(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: FETCH FIRST clause PERCENT option
Date: 2018-08-28 12:14:43
Message-ID: CALAY4q9oH4UxPrhX5gwiaAEvDf-7bivt9+gMR68GmPte11-mEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

On Tue, Aug 21, 2018 at 3:50 PM Andres Freund <andres(at)anarazel(dot)de> wrote:

>
> Imagine volatile functions being used. That can be problematic because
> of repeated side-effects, but also will lead to plainly wrong
> results. Consider what happens with your approach where somebody does
> something like WHERE value < random().
>
Thanks for explaining . The attach patch use tuplestore instead
Regards
Surafel

Attachment Content-Type Size
fetch-wth-percent-v2.patch text/x-patch 28.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2018-08-28 12:21:50 Re: BUG #15346: Replica fails to start after the crash
Previous Message Andrew Gierth 2018-08-28 11:29:04 Dimension limit in contrib/cube (dump/restore hazard?)