On Fri, Feb 17, 2012 at 17:31, David W Noon <dwnoon@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
