processing results from INTERSECT, UNION or EXCEPT

Поиск
Список
Период
Сортировка
От Jody Weissmann
Тема processing results from INTERSECT, UNION or EXCEPT
Дата
Msg-id 3A2FC278.A4AD05D9@ifi.unizh.ch
обсуждение исходный текст
Ответы Re: processing results from INTERSECT, UNION or EXCEPT
Список pgsql-novice
I'd like to do something as follows

SELECT t1.id FROM t1 WHERE t1.id IN (SELECT t2.id FROM t2 INTERSECT
SELECT t3.id FROM t3)

i.e. use results from a set-operation.
If i do this in psql, i get an error message

ERROR: parser: parse error at or near "intersect"

Is there any way to do this besides using a temporary table?

Thanx,
  Jody


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