| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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 |
| 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?) |