Re: Multiple SELECT statements Using One WITH statement - Mailing list pgsql-general

On Thu, Jan 20, 2022 at 8:46 AM David G. Johnston <david.g.johnston@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!