Re: Multiple SELECT statements Using One WITH statement

[Ken Tanzer <ken.tanzer@xxxxxxxxx>]

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

Cheers,

Ken

--

AGENCY Software  

A Free Software data system

By and for non-profits

http://agency-software.org/

https://demo.agency-software.org/client

ken.tanzer@xxxxxxxxxxxxxxxxxxx

(253) 245-3801

Subscribe to the mailing list to

learn more about AGENCY or

follow the discussion.