Re: Strange behavior on non-existent field in subselect?

Поиск
Список
Период
Сортировка
От Ken Tanzer
Тема Re: Strange behavior on non-existent field in subselect?
Дата
Msg-id 4536A3BD.9040506@desc.org
обсуждение исходный текст
Ответ на Re: Strange behavior on non-existent field in subselect?  (Ragnar <gnari@hive.is>)
Список pgsql-general
Thanks for the response Ragnar.  I would have expected this query to
fail, since the sub-query doesn't work by itself:

>> SELECT foo_field FROM foo WHERE foo_field IN (SELECT foo_field FROM par);

But it obviously doesn't.  So does that subselect implicitly read as:

IN (SELECT foo_field FROM par,foo);

Thanks for your help!

Ken





Вложения

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Real time query analyzer
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Real time query analyzer