Re: Set returning functions in select column list

From: David W Noon <dwnoon(at)ntlworld(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Set returning functions in select column list
Date: 2012-02-17 15:31:40
Message-ID: 20120217153140.0df88aad@abydos.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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]
======================================================================
dwnoon(at)ntlworld(dot)com (David W Noon)
======================================================================

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marti Raudsepp 2012-02-17 16:01:36 Re: MySQL search query is not executing in Postgres DB
Previous Message Tom Lane 2012-02-17 15:30:47 Re: Set returning functions in select column list