Re: Playing with set returning functions in SELECT list - behaviour intended? - Mailing list pgsql-general

David Fetter <david@fetter.org> writes:
> On Tue, Jun 16, 2009 at 10:06:54AM -0400, Tom Lane wrote:
>> It's always been that way.  The lack of any obviously-sane way to
>> handle multiple SRFs in a targetlist is exactly why the feature is
>> looked on with disfavor.

> I must be missing something obvious.  Isn't the nested loop thing that
> happens with generate_series() pretty sane?

You've carefully chosen a case in which the LCM is also the product.
Try some other combinations of periods and see if you still think
it's sane.

            regards, tom lane