True,
but it still allowed me to write queries that I do not know how to
express otherwise.
Am 20.09.10 01:58, schrieb Tom Lane:
> =?UTF-8?B?SmFubiBSw7ZkZXI=?= <roederja(at)ethz(dot)ch> 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 sane way to define the behavior is the main argument
> for deprecating SRFs in the targetlist.
>
> regards, tom lane
>