On Tue, Jun 16, 2009 at 10:06:54AM -0400, Tom Lane wrote: > "Albe Laurenz" <[email protected]> writes: > > So it looks like the number of result rows is the least common > > multiple of the cardinalities of all columns in the select list. > > 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? SELECT generate_series(1,2) AS i, generate_series(1,3) AS j; i | j ---+--- 1 | 1 2 | 2 1 | 3 2 | 1 1 | 2 2 | 3 (6 rows) Cheers, David. -- David Fetter <[email protected]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [email protected] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
