Re: generate_series

Thom Brown <thom(at)linux(dot)com> writes:
> On 15 February 2011 02:06, YAMAMOTO Takashi <yamt(at)mwd(dot)biglobe(dot)ne(dot)jp> wrote:
>> the following behaviour of multiple generate_series in a select seems
>> a little counter-intuitive to me.

> The output of such queries will keep producing output until all
> generate_series functions are at their end simultaneously.

Right, so the actual number of result rows is the least common multiple
of their periods. This is undocumented because nobody is very happy
with it and we don't want users relying on it. Eventually we may
deprecate set-returning functions in SELECT's targetlist altogether,
but that won't happen until there's an adequate replacement (possibly
LATERAL). In the meantime it's best to avoid having more than one per
SELECT.

regards, tom lane