Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0949JB63548 for ; Mon, 8 Jan 2001 23:09:20 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f0949EJ29571; Mon, 8 Jan 2001 23:09:14 -0500 (EST) To: "Robert B. Easter" cc: pgsql-sql@postgresql.org Subject: Re: Sv: how to build this query ??? Please help !!! In-reply-to: <0101081724411I.09559@comptechnews> References: <21122.978601587@sss.pgh.pa.us> <3A545AF2.1C827233@debis.com> <0101081724411I.09559@comptechnews> Comments: In-reply-to "Robert B. Easter" message dated "Mon, 08 Jan 2001 17:24:41 -0500" Date: Mon, 08 Jan 2001 23:09:14 -0500 Message-ID: <29568.979013354@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200101/82 X-Sequence-Number: 743 "Robert B. Easter" writes: > -- this crashes > select a, (SELECT b FROM y WHERE y.b = x.a + 1) AS b > FROM x WHERE a IN (SELECT b FROM y) > GROUP BY a,b > HAVING a IN (SELECT b FROM y WHERE b > 1); Fixed. 'Twas another case of trying to close a subplan twice ... regards, tom lane