WITH and WITH RECURSIVE in single query

From: Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: WITH and WITH RECURSIVE in single query
Date: 2011-12-05 03:28:55
Message-ID: CAK-MWwQzEux+BW3twFoFfEhLKfW+f4bYs6pZUwZsXLdsr6s8KQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-12-05 03:41:44 Re: WITH and WITH RECURSIVE in single query
Previous Message Craig Ringer 2011-12-05 00:25:31 Re: BUG #6325: Useless Index updates