RE: Multiple SELECT statements Using One WITH statement

[Avi Weinberg <AviW@xxxxxxxxx>]

 

Thanks David for the reply, but my question was a little different.

I know I can have multiple CTE queries like you showed, but I want to have one single WITH query, and use it in multiple queries, not just by one query the directly proceed the CTE. 

Why do I need to execute the CTE query twice if I have two queries that wants to use it?

 

Thanks

 

From: David G. Johnston [mailto:david.g.johnston@xxxxxxxxx]
Sent: Thursday, January 20, 2022 2:58 PM
To: Avi Weinberg <AviW@xxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Multiple SELECT statements Using One WITH statement

 

On Thursday, January 20, 2022, Avi Weinberg <AviW@xxxxxxxxx> wrote:

Hi,

 

Can I have multiple select statements using one WITH statement?

 

WITH t AS (

    Select A, B from …

)

SELECT A into tableA FROM t where ….;

 

SELECT B into tableB FROM t where ….;

 

With q1 as (), q2 as (), q3 as () main_query

 

David J.

 

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.