Re: [PORTS] Port Bug Report: Joins (does not support outer, left, right)

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: [PORTS] Port Bug Report: Joins (does not support outer, left, right)
Дата
Msg-id 375405F0.4718BCBF@alumni.caltech.edu
обсуждение исходный текст
Ответ на Port Bug Report: Joins (does not support outer, left, right)  (Unprivileged user <nobody>)
Список pgsql-ports
Дерево обсуждения 
> Summary: Joins (does not support outer, left, right)
> We were wondering if there is any method of limiting the result
> set of a quary to mimic an outer or left join with out using
> the keywords outer and left.

For a left outer join:

select <cols> from t1, t2
 where t1.x = t2.x
union
select <t1 cols>, null,... from t1
 where t1.x not in (select t2.x from t2);


--
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California

В списке pgsql-ports по дате отправления:

Предыдущее
От: Unprivileged user
Дата:
Сообщение: Port Bug Report: ./configure with message installation or configuration problem: C compiler cannot create executables.
Следующее
От: "Stawnyczy, Evan"
Дата:
Сообщение: A Question.