On Thu, Jan 20, 2022 at 4:32 PM Ken Tanzer <ken.tanzer@gmail.com> wrote: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 ASWITH 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 justCREATE 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.
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 ASWITH 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 justCREATE VIEW cte_view AS(...);Just curious, in case I'm missing something!
You can always write:CREATE VIEW cte_view ASWITH cte AS (...)SELECT * FROM cte;And then incorporate that into any queries that require the results of said CTE.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
