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

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: Full outer join? Cross product? How to blend two queries into single row?
Дата
Msg-id 396486430809041458g4d066f55q10581553f67b75cb@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Full outer join? Cross product? How to blend two queries into single row?  (Sam Mason <sam@samason.me.uk>)
Ответы Re: Full outer join? Cross product? How to blend two queries into single row?  (Sam Mason <sam@samason.me.uk>)
Список 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 по дате отправления:

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: Full outer join? Cross product? How to blend two queries into single row?
Следующее
От: Sam Mason
Дата:
Сообщение: Re: Full outer join? Cross product? How to blend two queries into single row?