Re: Proposing WITH ITERATIVE

Поиск
Список
Период
Сортировка
От Jonah H. Harris
Тема Re: Proposing WITH ITERATIVE
Дата
Msg-id CADUqk8X_RAAXiugxtzW7_BufTbsbyp9URpXan06Gjnth53au+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposing WITH ITERATIVE  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: Proposing WITH ITERATIVE
Список pgsql-hackers
On Wed, Apr 29, 2020 at 7:22 AM Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote:
Yeah the RECURSIVE vs ITERATIVE is a bit of a red herring here.  As you
say, the RECURSIVE keyword doesn't specify the processing but marks the
fact that the specification of the query is recursive.

Agreed. I started thinking through Fabien's response last night.

I think a syntax that would fit better within the existing framework
would be something like

WITH RECURSIVE t AS (
     SELECT base case
   REPLACE ALL  -- instead of UNION ALL
     SELECT recursive case
)

I was originally thinking more along the lines of Fabien's approach, but this is similarly interesting.

--
Jonah H. Harris

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

Предыдущее
От: James Coleman
Дата:
Сообщение: Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays
Следующее
От: Antonin Houska
Дата:
Сообщение: Accidental use of the PVC_RECURSE_WINDOWFUNCS flag?