Re: Full outer join? Cross product? How to blend two queries into single row?

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Sam Mason" <sam(at)samason(dot)me(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Full outer join? Cross product? How to blend two queries into single row?
Date: 2008-09-04 21:58:39
Message-ID: 396486430809041458g4d066f55q10581553f67b75cb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 4, 2008 at 2:54 PM, Sam Mason <sam(at)samason(dot)me(dot)uk> wrote:
> SELECT * FROM foo FULL OUTER CROSS JOIN bar;
>
> Admittedly, there aren't too many use cases for this! But it would make
> things a bit more regular.

SELECT * FROM foo, bar;

Isn't this have the same results, but with out the cross join?

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2008-09-04 22:06:18 Re: Full outer join? Cross product? How to blend two queries into single row?
Previous Message Sam Mason 2008-09-04 21:54:15 Re: Full outer join? Cross product? How to blend two queries into single row?