WITH and WITH RECURSIVE in single query

Поиск
Список
Период
Сортировка
От Maxim Boguk
Тема WITH and WITH RECURSIVE in single query
Дата
Msg-id CAK-MWwQzEux+BW3twFoFfEhLKfW+f4bYs6pZUwZsXLdsr6s8KQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: WITH and WITH RECURSIVE in single query
Re: WITH and WITH RECURSIVE in single query
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Shared memory usage in PostgreSQL 9.1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: WITH and WITH RECURSIVE in single query