Received: from double.nlr.ru (double.nlr.ru [212.193.3.3]) by hub.org (8.10.1/8.10.1) with ESMTP id e7MA3lT65178 for ; Tue, 22 Aug 2000 06:03:47 -0400 (EDT) Received: by double.nlr.ru (8.9.3/8.9.3) with ESMTP id OAA10253 Date: Tue, 22 Aug 2000 14:03:42 +0400 From: Alex Guryanow X-Mailer: The Bat! (v1.35) UNREG / CD5BF9353B3B7091 Reply-To: gav X-Priority: 3 (Normal) Message-ID: <6585.000822@nlr.ru> To: pgsql-sql@postgresql.org Subject: using INTERSECT and UNION in IN clause X-Sender: Alex Guryanow Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/219 Hi, postgresql 7.0.2. Why by executing the following query select * from magazine where id in ( select mag_id from dict where word = 'akademie' intersect select mag_id from dict where word = 'der' intersect select mag_id from dict where word = 'klasse' ) I receive the following error: ERROR: parse error at or near 'intersect' while the query select mag_id from dict where word = 'akademie' intersect select mag_id from dict where word = 'der' intersect select mag_id from dict where word = 'klasse' ) is executed successfully. Is it possible to use INTERSECT and UNION keywords in subqueries? Regards, Alex