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. David J.
