On Fri, Feb 17, 2012 at 17:31, David W Noon <dwnoon@ntlworld.com> wrote:
> The words to search for are "Cartesian product". This is the way
> RDBMSes have handled unconstrained implicit joins since the days of
> SQL/DS.
Yeah, that's what Jack was confused about -- it's actually *not* a
cartesian product. It simply stops enumerating when all the SRFs reach
the end at the same time.
Both of these queries generate 6 rows, although a cartesian product
would mean 12 in the second query:
select generate_series(1,2), generate_series(1,3);
select generate_series(1,2), generate_series(1,6);
Regards,
Marti