Re: Set returning functions in select column list - Mailing list pgsql-general

From David W Noon
Subject Re: Set returning functions in select column list
Date
Msg-id 20120217131900.74ca636a@abydos.local
Whole thread Raw
In response to Set returning functions in select column list  (Jack Christensen <jackc@hylesanderson.edu>)
List pgsql-general
On Thu, 16 Feb 2012 13:19:16 -0600, Jack Christensen wrote about
[GENERAL] Set returning functions in select column list:

[snip]
> I really don't understand what is going on here. I have checked
> Google and the PostgreSQL docs, but it appears either I do not know
> the key words to search for or it is sparsely documented.

The words to search for are "Cartesian product".  This is the way
RDBMSes have handled unconstrained implicit joins since the days of
SQL/DS.
--
Regards,

Dave  [RLU #314465]
=======================================================================
david.w.noon@ntlworld.com (David W Noon)
=======================================================================

pgsql-general by date:

Previous
From: David W Noon
Date:
Subject: Re: Set returning functions in select column list
Next
From: Marti Raudsepp
Date:
Subject: Re: MySQL search query is not executing in Postgres DB