Re: correlated delete with 'in' and 'left outer join'

Поиск
Список
Период
Сортировка
От Mike Mascari
Тема Re: correlated delete with 'in' and 'left outer join'
Дата
Msg-id 403F8656.6030704@mascari.com
обсуждение исходный текст
Ответ на Re: correlated delete with 'in' and 'left outer join'  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-general
Stephan Szabo wrote:

> ON conditions and WHERE conditions are different.
>
> Try
> select foo.key, bar.key from foo left outer join bar on foo.key=bar.key
> where bar.key is null;

Yep. Sorry.

Mike Mascari



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

Предыдущее
От: Michael Chaney
Дата:
Сообщение: Re: field must appear in the GROUP BY clause or be used in an aggregate function?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: field must appear in the GROUP BY clause or be used