Postgres Pro
Downloads
Home   >   mailing lists

WITH and WITH RECURSIVE in single query - Mailing list pgsql-general

From Maxim Boguk
Subject WITH and WITH RECURSIVE in single query
Date
Msg-id CAK-MWwQzEux+BW3twFoFfEhLKfW+f4bYs6pZUwZsXLdsr6s8KQ@mail.gmail.com
Whole thread Raw
Responses Re: WITH and WITH RECURSIVE in single query  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: WITH and WITH RECURSIVE in single query  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view
Hi.

Is here any way to combine WITH and WITH RECURSIVE into single query?

Something like:

WITH t AS (some complicated select to speed up recursive part),
RECURSIVE r AS
(
...
UNION ALL
...
)

?

--
Maxim Boguk
Senior Postgresql DBA.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Shared memory usage in PostgreSQL 9.1
Next
From: Tom Lane
Date:
Subject: Re: WITH and WITH RECURSIVE in single query