Postgres Pro
Downloads
Home   >   mailing lists

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

From Ken Tanzer
Subject Re: Multiple SELECT statements Using One WITH statement
Date
Msg-id CAD3a31X8WPvxiigFObf46Eui4aGF_c6HBmNTQpqN7zi5Hhqpgg@mail.gmail.com
Whole thread Raw
In response to Re: Multiple SELECT statements Using One WITH statement  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Multiple SELECT statements Using One WITH statement
List pgsql-general
Tree view


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!

Cheers,
Ken


--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: psql does not provide proper response
Next
From: "David G. Johnston"
Date:
Subject: Re: Multiple SELECT statements Using One WITH statement