Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Multiple SELECT statements Using One WITH statement
Date
Msg-id CAKFQuwatCDPT0tNojn5fVQ7NOkUgcZb9n5=GRRLz-gHF+XDddA@mail.gmail.com
Whole thread Raw
In response to Multiple SELECT statements Using One WITH statement  (Avi Weinberg <AviW@gilat.com>)
Responses RE: Multiple SELECT statements Using One WITH statement  (Avi Weinberg <AviW@gilat.com>)
List pgsql-general
Tree view


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 ….;


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

David J.
 

pgsql-general by date:

Previous
From: Avi Weinberg
Date:
Subject: Multiple SELECT statements Using One WITH statement
Next
From: Tom Lane
Date:
Subject: Re: Cannot find hstore operator