On Sun, Oct 1, 2023 at 8:57 AM Zhang Mingli wrote:
> And if it’s true, shall we skip the order by clause for Materialized
> View when executing create/refresh statement?
>
We tend to do precisely what the user writes into their query. If they
don't want an order by they can remove it. I don't
HI,
> On Oct 1, 2023, at 22:54, Tom Lane wrote:
>
> For one example,
> you can't just remove the sort clause if the query uses DISTINCT ON
Hi, Tom, got it, thanks,
Zhang Mingli
HashData https://www.hashdata.xyz
Zhang Mingli writes:
> When create or refresh a Materialized View, if the view’s query has order
> by, we may sort and insert the sorted data into view.
Indeed.
> And if it’s true, shall we skip the order by clause for Materialized View
> when executing create/refresh statement?
No. The in
