Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fASI8gm86955 for ; Wed, 28 Nov 2001 13:08:42 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fASHqK886481 for pgsql-sql@postgresql.org; Wed, 28 Nov 2001 12:52:20 -0500 (EST) (envelope-from news) From: Carl van Tast X-Newsgroups: comp.databases.postgresql.sql Subject: Re: PL/pgSQL loops? Date: Wed, 28 Nov 2001 18:52:49 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 36 Message-ID: <9f8a0uccirf0f38ijrdmref7rqeo4tv6vd@4ax.com> References: <200111281540250450.0093EFC2@mail.halfahead.dk> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: scrappy@hub.org X-Newsreader: Forte Agent 1.8/32.548 To: pgsql-sql@postgresql.org X-Archive-Number: 200111/387 X-Sequence-Number: 5769 On Wed, 28 Nov 2001 14:49:42 +0000 (UTC), pgsql@halfahead.dk ("Johnny Jørgensen") wrote: > << order_loop >> > FOR cur_order IN SELECT * FROM ordre WHERE person_id =3D p_id AND status = >=3D 1 AND id !=3D o_id > LOOP > RAISE NOTICE ''outer: %'',cur_order.id; > > << item_loop >> > FOR cur_item IN SELECT * FROM item WHERE order_id =3D cur_order_id > LOOP > RAISE NOTICE ''inner: %'',cur_item.id; > > UPDATE item SET ordre_id =3D o_id WHERE id =3D cur_item.id; > > END LOOP; > > UPDATE ordre SET status =3D 0 WHERE id =3D cur_order.id; > > END LOOP; Don't know much about LOOPs. But wouldn't this do want you want? UPDATE item SET ordre_id = o_id FROM ordre WHERE ordre.id = item.ordre_id AND ordre.person_id = p_id AND ordre.status = 1 AND ordre.id != o_id UPDATE ordre SET status = 0 WHERE person_id = p_id AND status = 1 AND id != o_id Kind regards, Carl van Tast