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 eBHI3O613856 for ; Sun, 17 Dec 2000 13:03:24 -0500 (EST) (envelope-from frank@joerdens.de) Received: from limedes.archi-me-des.de (pD90024D6.dip.t-dialin.net [217.0.36.214]) by rakete.joerdens.de (8.9.3/8.9.3) with ESMTP id TAA11224 for ; Sun, 17 Dec 2000 19:23:02 +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 SAA18530 for ; Sun, 17 Dec 2000 18:48:06 +0100 Message-ID: <3A3CFFF9.3615E576@joerdens.de> Date: Sun, 17 Dec 2000 19:03:37 +0100 From: Frank Joerdens X-Mailer: Mozilla 4.72 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Subqueries in Non-SELECT Queries Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/184 X-Sequence-Number: 518 I am trying to do something that looks to me exactly like what's described in chapter 8.4 in the Postgresql book: test=> UPDATE salesorder test-> SET ship_date = '11/16/96' test-> WHERE customer_id = ( test(> SELECT customer_id test(> FROM customer test(> WHERE name = 'Fleer Gearworks, Inc.' test(> ); UPDATE 1 Here only one row is updated. This should work with more than one, right? I get an error which suggests that it doesn't: mpi=# update index set level = 2 where parentid = ( select id from index where level = 1 ); ERROR: More than one tuple returned by a subselect used as an expression. mpi=# This is a recursive query, on a single table. Is that not possible? I am using 7.1. - Frank