On Thu, Jan 20, 2022 at 4:34 PM David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Thu, Jan 20, 2022 at 4:32 PM Ken Tanzer <ken.tan...@gmail.com> wrote: > >> >> >> On Thu, Jan 20, 2022 at 8:46 AM David G. Johnston < >> david.g.johns...@gmail.com> wrote: >> >>> You can always write: >>> >>> CREATE VIEW cte_view AS >>> WITH cte AS (...) >>> SELECT * FROM cte; >>> >>> And then incorporate that into any queries that require the results of >>> said CTE. >>> >>> >> Is there any advantage to still using a CTE inside the view >> definition, and then selecting it? Instead of just >> >> CREATE VIEW cte_view AS >> (...); >> >> Just curious, in case I'm missing something! >> >> > No. That would be tunnel vision and early morning posting on my part. > > Though I suspect if the CTE had a MATERIALIZED modifier there would be a difference. You can force a view to be materialized. David J.
