RE: Multiple SELECT statements Using One WITH statement

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@gmail.com]
Sent: Thursday, January 20, 2022 2:58 PM
To: Avi Weinberg <AviW@gilat.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Multiple SELECT statements Using One WITH statement

On Thursday, January 20, 2022, Avi Weinberg <AviW@gilat.com> 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 ….;