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

From Avi Weinberg
Subject Multiple SELECT statements Using One WITH statement
Date
Msg-id DB9PR07MB7180D7EB60AC27E3409E1572CB5A9@DB9PR07MB7180.eurprd07.prod.outlook.com
Whole thread Raw
Responses Re: Multiple SELECT statements Using One WITH statement  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Multiple SELECT statements Using One WITH statement  (Josef Šimánek <josef.simanek@gmail.com>)
List pgsql-general

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

 

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.

pgsql-general by date:

Previous
From: o1bigtenor
Date:
Subject: Re: Can we get the CTID value
Next
From: "David G. Johnston"
Date:
Subject: Re: Multiple SELECT statements Using One WITH statement