Re: Full outer join? Cross product? How to blend two queries into single row? - Mailing list pgsql-general

From Richard Broersma
Subject Re: Full outer join? Cross product? How to blend two queries into single row?
Date
Msg-id 396486430809041458g4d066f55q10581553f67b75cb@mail.gmail.com
Whole thread Raw
In response to Re: Full outer join? Cross product? How to blend two queries into single row?  (Sam Mason <sam@samason.me.uk>)
Responses Re: Full outer join? Cross product? How to blend two queries into single row?  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
On Thu, Sep 4, 2008 at 2:54 PM, Sam Mason <sam@samason.me.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

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Full outer join? Cross product? How to blend two queries into single row?
Next
From: Sam Mason
Date:
Subject: Re: Full outer join? Cross product? How to blend two queries into single row?