Re: Query generates infinite loop

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query generates infinite loop
Дата
Msg-id 3817754.1652114564@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Query generates infinite loop  (Corey Huinker <corey.huinker@gmail.com>)
Ответы Re: Query generates infinite loop  (Corey Huinker <corey.huinker@gmail.com>)
Список pgsql-hackers
Corey Huinker <corey.huinker@gmail.com> writes:
> The infinite-upper-bound-withlimit-pushdown counterexample makes sense, but
> seems like we're using generate_series() only because we lack a function
> that generates a series of N elements, without a specified upper bound,
> something like

>      generate_finite_series( start, step, num_elements )

Yeah, that could be a reasonable thing to add.

> And if we did that, I'd lobby that we have one that takes dates as well as
> one that takes timestamps, because that was my reason for starting the
> thread above.

Less sure about that.  ISTM the reason that the previous proposal failed
was that it introduced too much ambiguity about how to resolve
unknown-type arguments.  Wouldn't the same problems arise here?

            regards, tom lane



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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: postgres_fdw "parallel_commit" docs
Следующее
От: "Euler Taveira"
Дата:
Сообщение: Re: Privileges on PUBLICATION