Received: from rakete.joerdens.de (rakete.joerdens.de [62.104.116.200]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBIAh8674728 for ; Mon, 18 Dec 2000 05:43:08 -0500 (EST) (envelope-from frank@joerdens.de) Received: from limedes.archi-me-des.de (pD9055EE5.dip.t-dialin.net [217.5.94.229]) by rakete.joerdens.de (8.9.3/8.9.3) with ESMTP id MAA12882; Mon, 18 Dec 2000 12:02:51 +0100 Received: from joerdens.de (tricky.archi-me-des.de [192.168.100.1]) by limedes.archi-me-des.de (8.9.3/8.9.3) with ESMTP id LAA19976; Mon, 18 Dec 2000 11:27:44 +0100 Message-ID: <3A3DEA49.EA53DCEB@joerdens.de> Date: Mon, 18 Dec 2000 11:43:21 +0100 From: Frank Joerdens X-Mailer: Mozilla 4.72 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: Christof Glaser CC: pgsql-sql@postgresql.org Subject: Re: Subqueries in Non-SELECT Queries References: <3A3CFFF9.3615E576@joerdens.de> <00121719325000.15220@pinguin> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/193 X-Sequence-Number: 527 Christof Glaser wrote: [ . . . ] > since the where clause compares just one field for equality. You might > try IN instead of =, ie > > update index set level = 2 where parentid in ( select id from > index where level = 1 ); That was it! Thanks, Frank