subselect field "problem"
От | Thomas H. |
---|---|
Тема | subselect field "problem" |
Дата | |
Msg-id | 47337307.30902@alternize.com обсуждение исходный текст |
Ответы |
Re: subselect field "problem"
|
Список | pgsql-general |
hi list i was writing the query below containing a subquery. by mistake, i referenced a field from the main table in the subquery, leading to a very strange (but working??) result. the planner announced a insanely high startup cost, but the query itself finished pretty quickly. nevertheless, shouldn't pgsql warn the user if he's referencing a non-existing field in a subquery? the field referenced in the subqueries WHERE-clause doesn't exist in the subqueries table, thus i don't even understand why that wouldn't throw an error and how the result would have to be interpreted: SELECT * FROM titles WHERE tit_id IN ( SELECT DISTINCT nam_tit_id FROM names WHERE lower(tit_name) LIKE '%best%' ) the field "tit_name" is in "titles". the field i intented to use was "nam_name" from table "names"... regards, thomas
В списке pgsql-general по дате отправления: