Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e7MEH9T69633 for ; Tue, 22 Aug 2000 10:17:09 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id KAA05662; Tue, 22 Aug 2000 10:16:54 -0400 (EDT) To: gav cc: pgsql-sql@postgresql.org Subject: Re: using INTERSECT and UNION in IN clause In-reply-to: <6585.000822@nlr.ru> References: <6585.000822@nlr.ru> Comments: In-reply-to Alex Guryanow message dated "Tue, 22 Aug 2000 14:03:42 +0400" Date: Tue, 22 Aug 2000 10:16:54 -0400 Message-ID: <5659.966953814@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200008/223 Alex Guryanow writes: > Is it possible to use INTERSECT and UNION keywords in subqueries? No, not at the moment. This is one of many things we hope to fix when we redesign querytrees (currently planned for 7.2 cycle). regards, tom lane