Re: Re: Should we have an optional limit on the recursion depth of recursive CTEs?

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Re: Should we have an optional limit on the recursion depth of recursive CTEs?
Дата
Msg-id CAEYLb_XJjwYEX6gYYOP8y-2wzJOkzng3_tiTqvrnrP-zcrz+xg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: Should we have an optional limit on the recursion depth of recursive CTEs?  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Дерево обсуждения 
On 20 August 2011 15:34, Bruce Momjian <bruce@momjian.us> wrote:
> Actually, using UNION instead of UNION ALL does prevent some infinite
> loops:

While that is worth pointing out, it cannot be recommended as a way of
preventing infinite recursion; after all, all 5 WITH RECURSIVE
examples in the docs use UNION ALL. It's just a different way of
specifying a terminating condition that isn't likely to be applicable
to more complicated rCTEs.

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Re: Should we have an optional limit on the recursion depth of recursive CTEs?
Следующее
От: "Sergey E. Koposov"
Дата:
Сообщение: Re: two index bitmap scan of a big table & hash_seq_search