On Tue, Jun 16, 2009 at 10:06:54AM -0400, Tom Lane wrote:
> "Albe Laurenz" <laurenz.albe@wien.gv.at> 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 <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate