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

From Surafel Temesgen
Subject Re: FETCH FIRST clause PERCENT option
Date
Msg-id CALAY4q9oH4UxPrhX5gwiaAEvDf-7bivt9+gMR68GmPte11-mEw@mail.gmail.com
Whole thread Raw
In response to Re: FETCH FIRST clause PERCENT option  (Andres Freund <andres@anarazel.de>)
Responses Re: FETCH FIRST clause PERCENT option
List pgsql-hackers


On Tue, Aug 21, 2018 at 3:50 PM Andres Freund <andres@anarazel.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

pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Dimension limit in contrib/cube (dump/restore hazard?)
Next
From: Stephen Frost
Date:
Subject: Re: Would it be possible to have parallel archiving?