=?UTF-8?B?SmFubiBSw7ZkZXI=?= writes:
> Ok I now know that it really seems to do what I expected. But I still
> wonder what it does if I use two functions f() and g() that return a
> different number of rows.
You get the least common multiple of their periods. It's ugly, and the
lack of any very
Ok I now know that it really seems to do what I expected. But I still
wonder what it does if I use two functions f() and g() that return a
different number of rows.
I'm guessing a query such as
SELECT id, (f(id)).a, (g(id)).b when f returns 3 rows and g returns two
row would yield something like